Hi.
Thanks for some info. I soved the problem!!!!! After much searching all over
the net, but finally used
Balters's Access 2000 Dev book. Wow.
The problem was to load a current 'Client' table from an excel spreadsheet.
The 'Client' table also has several many-to-one relationships to several
other tables that further define a client. Some examples... Address State
Abbrevs, Client Status, Contact Type.
So there were two issues...
1.) How to map the data field by field from the excel to the current Client
Table.
2.) How to map using relationships to store the table pointers for the
relationship. i.e pointer to the state table for state abbrev in address
using the 2 letter state code stored on the excel spreadsheet.
I did the "get external data' of the excel spreadsheet to create a WORK
Client Table which will be temporary.
I used 'create query in design mode' and (THIS IS IMPORTANT) selected the
the State table, the Client Status Table, Contact Type and the WORK Client
table . All of these are for the input side of the query. I then dragged
the state, status and client type data fields from the WORK client table to
the other tables to establish there relationships. This does the lookups to
get the correct ID's.
I then selected from the top toolbar, Query, Append Query and selected the
Clients Table which this data will get appended to. This creates an append
query.
I then draged the fields down to the lower grid and selected the matching
fields in the 'Append To'. For the relationship tables, I dragged the ID's
(or pointers) and not the data.
(A side note,, on some 'not required fields' on the client table, I had to
set 0 length okay.)
I ran the query and it worked. It set the correct pointers for all the
relationship tables too.
Fred
"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...
"Fred" <fg***************@yahoo.com> wrote in message
news:<bn************@ID-76446.news.uni-berlin.de>...
Hi.
How do I import while mapping an excel table to an access table
please??? I've searched around and all I can find is a software product or code
that does the same thing as the access wizard.....
If I have to write vb code, where is a sample???
Or do I import the excel in to a new spreadsheet and then
write some kind of querey to move the data from that table
to my current production table.. How do I do this?
Seems to me, access would be able to do this???
Thanks, ANY infor would be appreciated.!
Fred
Any reason you can't create an import specification and then just use it?
