By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,472 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

How to import/map excel table data to access table data?????

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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?
Nov 12 '05 #2

P: n/a
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?

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.