MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Importing Excel Sheet into Access Database


Posted by Qasim on November 05, 2001 1:41 PM

Can you guide me that how can I import an Excel sheet in to multiple tables of a database. As my sheet have different values and these values are for different tables. More over my excel shhet as Column vertically that means the name of the field for Access database are in vertical position.
Thanks
I will appreciate if you can email me.


Posted by GREGC on November 06, 2001 9:35 AM

The wizards are pretty decent at getting data from Excel into Access. If you need to do it often you can write code that will do it, more difficult, but not extremely hard. Try the wizard, and repost if that doesn't work.

Posted by Ziggy on November 16, 2001 8:41 PM

under tables click "NEW" then import, select your file and go through the steps with the wizard, watch you data types. You can also choose "link" intead of import. Linking will allow any changes made in the spreadsheet to be automatically updated in access. Anyways once imported you can use Queries to break up your spreadsheet by selecting only the fields you want. Also use a "Crosstab" Query since your fields are vertical.

Hope this helps

Ziggy