What I need is a code to convert a dbase table to a microsoft access database. Please help me
Printable View
What I need is a code to convert a dbase table to a microsoft access database. Please help me
How many times do you plan on converting the database?
Access will let you import DBbase tables, from the file menu.
What I need is that I need to enter a dbase file and convert it to access as many times
How about creating an Access database that has linkages to the dbase db?
I found this around into this site. Maybe it helps you:
http://www.vb-world.net/databases/tip132.html
Good Look!
Ulises
The suggestion about using links to the dbase data are not good suggestions any more... that functionality has been removed from Jet4. Careful if you based code on this method it will fail once you leave DAO3.5x
You can either fight the MS decision or get on with your work.
To import/convert on the fly from any ISAM(including Jet4) to any ISAM see:
http://www.smithvoice.com/vb5expt.htm
the gape implies VB5 but the single and superfast line of SQL is fine for any DAO ro ADOX2.1+ developer.
Also make sure you get the souce code demos, with them you can go pretty far and your specific question is answered step by step.
-Robert Smith
Kirkland WA