Excel to Access

anybody know how I can convert Excel data to Microsoft Access?

Nick
SolverSurferAsked:
Who is Participating?
 
wct097Connect With a Mentor Commented:
In MS Access (I think mine is 2000), there is an option under the file menu called "Get External Data".  Select it, then import.  The open dialog will come up, and you'll need to change the "Files of Type" drop down to MS Excell.  Find your spreadsheet and open it.  You'll be presented with a window asking how you want to import it.  Pretty simple once you know where to look.

HTH!
-Will
0
 
davidbartrumConnect With a Mentor Commented:
Should be straight forward.
Save your Excel file as a CSV (Comma Separated Values).
Then import into Access, ensuring you have a table defined with right number of columns and types.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.