>What's the easiest way to export to Access tables, given that it's not native to the COPY TO or EXPORT commands? With something like an XLS file, all the structure is created for you (i.e. you don't have to open Excel, create a spreadsheet, save it, then export to that spreadsheet). VFP just creates the spreadsheet and loads it up. Is there any way that can be done when exporting to Access? I've read from Access tables, but haven't created them from VFP. Naturally, Access is a single file with everything thrown in, whereas VFP tables are standalone, so something's got to create the MDB and then all the tables within. And since I'd be doing VFP tables one at a time, the first export process would need to create the MDB and the first table, then subsequent exports would need to just add another table (not recreate the MDB, of course).
>
>Thanks,
>
>Russell
I haven't tried this myself
DBC2MDB - Fox to Access Downsizer Download #
9847
If it's not broken, fix it until it is.
My Blog