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