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

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

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+
1 Reply


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