Export/Import Acces Table to another Acces table/file

[KimTong via AccessMonster.com]

Hi,

Is anybody can help me how to Export/import access table to another access
table/file only using 1 click button?. I am pretty sure Visual Basic can do
this. Thank's in advance, I am appreciated.


KFT

 

[krissco]

Hi,

Is anybody can help me how to Export/import access table to another access
table/file only using 1 click button?. I am pretty sure Visual Basic can do
this. Thank's in advance, I am appreciated.

KFT

Hmmm. It's difficult to know exactly what you are looking for. Are you
trying to accomplish something like this:

1. User specifies Input table name (already exists)
2. User specifies Output table name (does not exist)
3. User clicks a button and a "backup" is made of the table under the
new name.

Will both tables be within the same database? Your use of import/
export makes me wonder if you are working with multiple .mdb files.

-Kris