469,636 Members | 1,527 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,636 developers. It's quick & easy.

How to import/mpa excel table to access table????

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
1 6208
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Access can do that.

1. Open the db you want to import the Excel data into.
2. Select File from the menu bar.
3. Select Get External Data from the menu.
4. Select Import from the sub menu.
5. When the Open File dialog box opens select Microsoft Excel (*.xls)
from the "Files of Type" combo box, at the bottom of the dialog box.
6. Navigate to the Excel file you want to import.
7. Highlight it & click the Open button on the dialog box
8. Follow the instructions to complete the import.

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP5cPKIechKqOuFEgEQLy9QCeL6Ng5mxtL4ZbiVIjiO5QtO LL4UIAnjZP
ftcsxb04T6XgbjCJWEJoOOhQ
=/GkZ
-----END PGP SIGNATURE-----

Fred wrote:
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 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Johnny Meredith | last post: by
1 post views Thread by John Hewitt | last post: by
15 posts views Thread by daniroy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.