Import Visual FoxPro file using code

[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

 

[Cindy Winegarden]

Hi Amanda.

I notice in your connection string you refer to file names like x.DBC. If
there is a DBC file present then the tables were created with Visual Foxpro
and you will need to use the Visual FoxPro ODBC driver, available from
http://msdn.microsoft.com/vfoxpro/downloads/updates .