473,322 Members | 1,714 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Importing data from an External DB & Efficiency

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
"TransferSpreadsheet" 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
Nov 13 '05 #1
2 2286
On 20 Nov 2004 06:36:04 -0800, sa*******@yahoo.com (Sara) wrote:

There is a difference between importing and linking. In your case,
linking is good, importing is not. A link takes only a few bytes (to
hold the definition of the table structure and the location), so
overhead is minimal.
You link a table manually (File/Get External Data) or through code
(Connect, RefreshLink).
TransferSpreadsheet can be used to import into tables as well as into
linked tables. That's the route I would take. Efficient enough in the
vast majority of situations.

-Tom.
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
"TransferSpreadsheet" 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


Nov 13 '05 #2
sa*******@yahoo.com (Sara) wrote in message news:<d9**************************@posting.google. com>...
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
"TransferSpreadsheet" 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


Sara,

The difference between importing into internal and linked tables is
negligable if the databases reside on the same machine. On a LAN the
difference often is also very small, but when the machines have to
cummunicate over slower or very busy network-links the performance can
drop dramatically. Linking a table on a LAN is easy and in most cases
very efficient. The linked table approach is also very easy because
ther is no difference in importing into existing native or linked
tables. The same macro-commands (Transferspreadsheet) can be used and
the update-process can be centralized and more easily automated.

Marc
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Grim Reaper | last post by:
I am importing a .csv file into Access that has 37 fields. My problem is that sometimes the last field only has data at the end of the column (it looks like when you import a file into Access, for...
9
by: Edward S | last post by:
I budget for a Project in an Excel sheet as illustrated below. The months below are usually a 2 year period i.e. 24 months, though it could be over 24 months depending upon a Project. I then...
1
by: sparks | last post by:
I have never done this and wanted to ask people who have what is the best way. One person said import it to excel, then import it into access table. but since this will be done a lot, I am...
6
by: Sam Lazarus | last post by:
I need to import data from a website, but the text is arranged badly: Name:John Doe Title:Grunt ID:314159 Name:Jane Doe Title:Queen-Bee ID:271828 etc...
7
by: Darren | last post by:
I have been attempting to create a reservation planning form in excel that imports Data from an Access database and inserts that information automaticly into the correct spreed sheet and the...
2
by: kuhni | last post by:
Hi everybody, I am totally desperate because I cannot solve a really simple problem: I have a specific text-file which I want to import into an existing database. The problem is that the columns...
7
by: nizar.jouini | last post by:
Hello. I have long text file whitch is formatted like this: nextrow4 asdf asdf
3
by: Donald Grove | last post by:
I need to get data from a table in .dbf format. I try importing it, but get "external table not in expected format". So I tried this VB code to see if I could get at my records with ADO (which...
3
by: HistoricVFP | last post by:
Hello, I’ve been given the task of importing .dbf files from a very old version of Visual FoxPro (version 2.1) into Access (2003). When I import the data straight to Access it errors with: ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.