Split DB now what? Transferdatabase!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that gets source data from a bunch of different places
(databases, text files, spreadsheets). It was working fine then I split the
db. This gave me a bunch of new functionality but the data imports
(transferdatabase) is now putting the table in my front end. Is there a
clean way to use transferdatabase on the backend db from the frontend? I
could let it load to the new table on the frontend then append the records to
the linked table and delete the new table but that seems like a lot of
processing for loading a single table.

Any thoughts or help is greatly appreciated!!!!
 
One way is to use TransferDatabase to create a linked table in the front
end, then an append query to move the data from this temporary linked
table to the one that's linked to the back end.

Another is to use the IN clause in an append query, e.g.

INSERT INTO MyLinkedTable (Field1, Field2, Field3)
SELECT F1, F2, F3
FROM OtherTable IN "D:\Folder\Otherdatabase.mdb"
;
 
Back
Top