Import Visual FoxPro file using code

  • Thread starter amanda battye via AccessMonster.com
  • Start date
A

amanda battye via AccessMonster.com

I have regularly been importing Visual Foxpro files into my access
database. I now want to automate this procedure with code/macro. However
I'm having trouble with the sytax.

To get the Database Name property, I linked the required table and looked
at the table properties as suggested in the help file. However, it looks
like there are too many arguments within it to me.

Also not really sure what to put for source and destination.

This is the code I have so far:
DoCmd.TransferDatabase acImport, "ODBC", "ODBC;DSN=Visual FoxPro Tables;" &
_
"SourceDB=U:\Coldharbour\Comp_B.DBC;SourceType=DBC;Exclusive=No;" & _
"BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;;TABLE=wname", _
acTable, "u:\coldharbour\Comp_B.DBC", "wname_b", False

any help would be much appreciated.

Amanda
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top