importing dbf file (1 Viewer)

aqif

Registered User.
Local time
Today, 17:25
Joined
Jul 9, 2001
Messages
158
Hi :)

I am trying to import a DBaseIV *.dbf file which is sent to me from a different database. I need to import this file on monthly basis. When I tried to use import utility from File menu it worked perfectly. I just want to write a code which will do just that. I tried using Tranasfer Database but dont seem to figure out the Database Name as I just have a simple dbf file which I store in C:\Temp folder.

I will appreciate if someone will point me to right direction and will also appreciate if u could also point me to how to export one of my table in the same exact format.

Cheers!
Aqif
 

charityg

Registered User.
Local time
Today, 17:25
Joined
Apr 17, 2001
Messages
634
Do you know what the name of this simple dbf file is? Where does the dbf file come from?
 

aqif

Registered User.
Local time
Today, 17:25
Joined
Jul 9, 2001
Messages
158
Also help me with Export

Yes .......

name of file is Temp.dbf
name of folder C:\Temp

I also want to reverse the process by exporting a table in my db called TblExport into a single file called TempEx.dbf

I really appreciate ur efforts regarding that.

Cheers!
Aqif
 

cogent1

Registered User.
Local time
Today, 17:25
Joined
May 20, 2002
Messages
315
To import:

DoCmd.TransferDatabase acImport, "Dbase 5.0", "C:\Temp", acTable, TableName1, TableName2

where Tablename1 is the source table and Tablename2 is the destination.

Export :

Same, but acExport instead of acImport
 

Users who are viewing this thread

Top Bottom