Hello all,
I have an access database using data imported from a FoxPro 2.6 table, exported as db IV filetype.
It would be very simple to use the Access import function (\Get external data\), but the problem is that the old table is not being replaced, but the new one is being renamed, which doesn't help (the user would have to manually delete the old table first, then the new table can be imported with the right name). Obviously, I have to do this w/o the user having to interfere in the process. Using Excel format is not an option as there are some 200 k lines of records, and it would also make the process too complex for some users...
Is this possible in a mdb database? How about in a mde database?
Thanks in advance.
Chris
I have an access database using data imported from a FoxPro 2.6 table, exported as db IV filetype.
It would be very simple to use the Access import function (\Get external data\), but the problem is that the old table is not being replaced, but the new one is being renamed, which doesn't help (the user would have to manually delete the old table first, then the new table can be imported with the right name). Obviously, I have to do this w/o the user having to interfere in the process. Using Excel format is not an option as there are some 200 k lines of records, and it would also make the process too complex for some users...
Is this possible in a mdb database? How about in a mde database?
Thanks in advance.
Chris
