importing into template

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

Guest

Is it possible to import data directly into an Access 2003 template. Example:
Using template #01018584 (Membership) when I go to Tables; Members and use
the "Get External Data" link. It imports the data, however it creates a new
folder.

Any suggestions on how to have the data go direct into the exisitng
"members" table. I realiaze it has something to do with field
names.......thanks in advance.

Using Office Professional 2003, also beta tested it for 2 years. P.S. Does
Business Contact Manager have any programs that help improve linking Access
and Outlook. I have the disc, but uninstalled it some time ago as it did not
seem to offer many features.

Tom Holser.
 
Hi Tom,

I don't understand what you mean by "it creates a new folder".
To import data into an existing table from an external table with a
different structure, the simplest thing is usually this:

1) use File|Get External Data|Link to link the external table
2) create an append query to move the data from the linked table to the
existing table, with calculated fields to change the field names and
make any other changes.

I haven't used the Business Contact Manager myself, precisely because it
seemed so limited. AFAIR it doesn't offer any extra facilities for
linking Outlook data with relational databases.
 
Is it possible to import data directly into an Access 2003 template.
Example: Using template #01018584 (Membership) when I go to Tables;
Members and use the "Get External Data" link. It imports the data,
however it creates a new folder.

Any suggestions on how to have the data go direct into the exisitng
"members" table. I realiaze it has something to do with field
names.......thanks in advance.

Using Office Professional 2003, also beta tested it for 2 years. P.S.
Does Business Contact Manager have any programs that help improve
linking Access and Outlook. I have the disc, but uninstalled it some
time ago as it did not seem to offer many features.

Tom Holser.
Click to expand...

You can very well import an Excel worksheet and add the data to an
existing table!

Make certain that the column headings in Excel are exactly the same as
your field names in the table where you want to put them.
To avoid overwriting existing records, your main field should be indexed,
no duplicates.

Go through: File/Get external data/Import/File type: xls/
Select name of Excel file
Select worksheet
Tick: First row contains titles
Save where?
Existing table
Select table
Confirm

(Some of the terms might be slightly off; I'm using a localized Dutch
version of Access 2000 but you probably get my intentions.)

After that the import should roll. If records are missed or rejected,
that might be because the unique field cannot be overwritten or de data
in some field(s) might be of the incorrect type.

I cannot help you with Outlook as I refuse to use it. I'm a fan of the
Mozilla's. Far less sensitive to corruption through the internet.
 
Back
Top