Import a table creates a new table

  • Thread starter Thread starter Kevbro7189
  • Start date Start date
K

Kevbro7189

Ok I have these two Access DB which have the same table (same fields, and
properties) the first database (DBPART) gets updated with new data from time
to time. So I want the second database (DBLOG) to update off of DBPART.

I built a micro to import the table (TBLIST) from DBPART to LOG.

TransferDatabase Import, Microsoft Access, =([Text23]), Table, TBLIST,
TBLIST, No
Note “=([Text23])†is the way I used for the user to input the location of
DBPART

My problem is when TBLIST is imported to DBLOG a new table is created as
TBLIST1, then TBLIST2, TBLIST3.............. The data never gets into TBLIST.
 
Thanks Jeff. It took me a while to get it down but the append query worked
like a champ!


Jeff Boyce said:
"Import" means add a copy.

Perhaps you want to use "link", or maybe you could use an append query to
add records.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Kevbro7189 said:
Ok I have these two Access DB which have the same table (same fields, and
properties) the first database (DBPART) gets updated with new data from time
to time. So I want the second database (DBLOG) to update off of DBPART.

I built a micro to import the table (TBLIST) from DBPART to LOG.

TransferDatabase Import, Microsoft Access, =([Text23]), Table, TBLIST,
TBLIST, No
Note “=([Text23])†is the way I used for the user to input the location of
DBPART

My problem is when TBLIST is imported to DBLOG a new table is created as
TBLIST1, then TBLIST2, TBLIST3.............. The data never gets into TBLIST.
Click to expand...
Click to expand...
 
Back
Top