How do I import tabular data from Excel into Access?

C

crazymfr

Is the wizard the best way to start, or is there an insider way to start?

Please let me know, not sure if i'm using this passport correctly.
 
A

Arvin Meyer [MVP]

crazymfr said:
Is the wizard the best way to start, or is there an insider way to start?

Please let me know, not sure if i'm using this passport correctly.
Click to expand...

You can import or link an Excel spreadsheet. Make sure that the data or
column headers start at the first row and that there's no fancy formatting
to create problems with field identification.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top