Import a table creates a new table

[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.

 

[Jeff Boyce]

"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]

Thanks Jeff. It took me a while to get it down but the append query worked
like a champ!

"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/

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.