Don,

Not knowing anything about Access, I would do it by creating two OleDB connections: one to the VFP table and the other to the Access table. Then grab all the rows from the VFP table via that connection, and then write them to the Access table. You can do it with a DataReader or a DataAdapter and a DataSet. This is definitely *not* the most efficient way to do this, particularly if you have a large table that you're importing. You probably are looking more for a way to execute a batch import script directly from Access (since you've started it via automation) ... but I can't help you with that. I just thought I'd give you an alternative if no one else chimes in with an answer. -g-

~~Bonnie




>Does anyone have a VB script that will import a VFP table into MS Access? The table has been created with a SELECT . . . INTO TABLE and the import works OK manually. I can start Access via automation but can't figure the code to execute the import.
>
>As an aside, is there a way to get Access macro code the way you can in Excel? IE create the macro then edit . . .etc.
>
>Thanks