Split DB now what? Transferdatabase!!!

E

ES

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!!!!
 
J

John Nurick

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top