Import a dbf or a tab delimited file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear friends,

I need to import a dbase file (dbf) / tab delimited text file in my Access
database. I need to import all records and all fields (approxiamately 10000
records and 5 fields).

I need to do that so I can then import some of those records (new records)
in my main table. So, i need to import this file once a week, always using
the same filename(dbase or txt) and the same tablename (in my access
database) to be imported.

I will then use a find unmatch query in order to find the new records and
then append them in my main table. ( I know, that i will first empty that
table and then to import the dbase file)

How can I achieve this - import the dbase/txt file in my access database?
Either using a macro or VBA?
 
Sorry for bothering you,

I should search the best site first (and of course in mean the current one).

DoCmd.DeleteObject acTable, "testdb3"
DoCmd.TransferDatabase acImport, "dBase 5.0", "C:\new1", acTable, "TESTDB3",
"TESTDB3"
MsgBox "Transfer completed"

Ο χÏήστης "George" έγγÏαψε:
 
Back
Top