importing a dbf in a access database...

hello,

My question is the following ;

How can i import (as fast as possible) a dbase (dbf) database in access (mdb)database.


If it's possible, give a small example in code...

- Any fool can know, the point is to understand -

You can import a dbase database into Access by following the steps:

1. Open Access database from Start>Programs>Microsoft Access
2. Select Blank Database option and click OK.
3. It will prompt with a dialog box for "File New database".Create a database by giving some name Ex: database1 and click "Create" Button.
4. Then you will see Access database with Tables,Queries,Forms,Reports,Macros & Modules.Click the "New" button and you will see a dialog box with Dtasheet view,Design view,Table,import and link.
5. Click on the import table and then click ok.
6. You will see a Import dialog box.In that click the "Files of Type" combo box and select dBASE III and then select the filename of your dBASE III database.
7.That's it... It will import the dBASE III database into Access database.And you can start viewing your database..

Hope this is clear to you.

Regards

Well, jeeze...thanks for your reply ! But... how can i bring this to you....

I need this in VB code.

Anyway, thx

I'm positive there's a better way to do it, BUT

In code:

1. Open the database
2. Attach the dbf file
3. write a sql query to create a new table.

Like I said, there's got to be a better way, but this will
work. If the file were from another engine where you could
write a pass-thru query, you could do the same without
attaching the file.

Good Luck, and hope this helps
DerFarm

Do you have a little example in code for point 3?
I can go as for point 2.

With sql you mean "insert into..." ??

"Select * from tablename into NewTableName"



No secret about it, it is simply a make table query. Once
you have attached a table to an Access database, as far as
Access is concerned, it is a native table.

You can also read data from Access Databases that are NOT
connected. I have an example, but its in the other
machine, and the e-mail isn't working. Essentially, you

Select blah-blah from blah-blah IN FILENAME

Once you specify IN FILENAME, you are essentially writing a
pass-thru.

Good Luck
DerFarm

thx derfarm,

i'm sure gonna try.