Importing data

[Linda31]

Hi all. I need to import data from an ACT db to Access. I cannot directly link Table to db because of multi users. ACT db is on the network, and I need to update the Customer table in Access with the info from ACT. The code I currently have is:

Testing\Documents and Settings\Act\Cust.dbf
(Computer\Folder\Folder\db)

Is this right?

Thanks

 

[AncientOne]

Your code should take the form:

DoCmd.TransferDatabase acImport, "Dbase 5.0", "\\Testing\Documents and Settings\Act\
", acTable, "cust.dbf", "tblMyTable"

or you can import manually using the menu File/getExternal data

 

[Linda31]

Thank you ancient one. I actually figured it out. I appreciate your reply.