paste/append in vba?

[gasp]

is there a way to paste append between two tables
in Access vba? the first table is imported from
excel ( generated by a foxpro program and then
resaved as an excell workbook )

unfortunately i can't import directly into the table
i need because for some reason it blows away the table
properties that need to be there. and it's a bit tiresome
to have to open a table, copy, switch tables, paste append,
close everything ( don't forget to clear the clipboard! )
etc...every single morning.

any ideas?

 

[Nordyck]

Access will read foxpro files directly and saves all of the field property. In both 97 and 2000 has a module that needs to be installed that will allow it to read foxpro files. Once that is installed, then its just like linking to a table in another access database and you have full use of append query without any loss of data or properties. (I've done this many times in the past.)

Good luck