Hi -
I've been reading the posts for a solution to my query, and realize
that I should ask an "approch" question as well.
We receive our production data from a third party, so my uers import
the data from Excel into the appropriate tables. There are 6
different databases that receive data, though 4 of them only get one
table each.
I have learned how to automate the data import through
"TransferSpread sheet" and it works great. I have the user type in the
date for import from their daily form, and I go out to the server and
find all the files to import for that date.
My question relates to how I can import data to the other 4 databases
(one external db's table is already linked in the db with the form)
from this one. It will make the most sense to just have the user type
in the date once per day and click on "Import Data". The question is
how to do that.
I chose NOT to link the tables from the other 4 databases, as I don't
use that data at all in this database, and I figured it would be
inefficient, or make the .mde too big or something. So, I was looking
for code to allow me to import into a table that is in another
database and not linked in the current application. As I read the
posts, however, I see that maybe the best solution is to link the
tables? Maybe it doesn't impact efficiency, speed, etc.?
Those are my questions: Does linking impact efficiency? Should I
link or code? What command/code is used to import to a table in an
external Db?
Thanks in advance -
Sara
I've been reading the posts for a solution to my query, and realize
that I should ask an "approch" question as well.
We receive our production data from a third party, so my uers import
the data from Excel into the appropriate tables. There are 6
different databases that receive data, though 4 of them only get one
table each.
I have learned how to automate the data import through
"TransferSpread sheet" and it works great. I have the user type in the
date for import from their daily form, and I go out to the server and
find all the files to import for that date.
My question relates to how I can import data to the other 4 databases
(one external db's table is already linked in the db with the form)
from this one. It will make the most sense to just have the user type
in the date once per day and click on "Import Data". The question is
how to do that.
I chose NOT to link the tables from the other 4 databases, as I don't
use that data at all in this database, and I figured it would be
inefficient, or make the .mde too big or something. So, I was looking
for code to allow me to import into a table that is in another
database and not linked in the current application. As I read the
posts, however, I see that maybe the best solution is to link the
tables? Maybe it doesn't impact efficiency, speed, etc.?
Those are my questions: Does linking impact efficiency? Should I
link or code? What command/code is used to import to a table in an
external Db?
Thanks in advance -
Sara
Comment