Hi there,
I am trying to import a dbase file into an access database. Is there a way of doing this at a command level? I can do it using recordset but it's extremely slow. Pls help. thanks in advance.
Please I need a code.
Newvbguy
NewVBguy 3 Junior Poster in Training
~s.o.s~ 2,560 Failure as a human Team Colleague Featured Poster
Import a database file into Access Database.. ? Can you clarify by giving examples.. ?
NewVBguy 3 Junior Poster in Training
Oopps! sorry for that. It should be dbase file or dbf file into an ms access table.
thnx again
newvbguy
Import a database file into Access Database.. ? Can you clarify by giving examples.. ?
Ancient Dragon 5,243 Achieved Level 70 Team Colleague Featured Poster
I would imagine dbase has an export command to export the database to a text file. Then you should be able to use Access's import command to import it.
NewVBguy 3 Junior Poster in Training
Hi there,
can you post the access import command then.
thnx.
newvbguy
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.