Excel to Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I transfer a worksheet from Excel to a new Access database? Keep in
mind that I really don't know anything about Access, so I need to know
everything from the point of having the finished worksheet on.
 
Do it from ACCESS. Are you doing it manually or do you need it to work from
programming?
 
One easy way is to copy the spreadsheet including the header row and data.
Paste it to the table screen. It should ask you "does the first row contain
field names" and the choose yes. Then go into the database design and rethink
you text, number and other database issues.

There are other ways. Import the xls. Match the colums of the xls with a
table you designe. Copy and Paste Apend the data records.

A table in Access is somewhat like a table in Excel.
 
In Tables select New/Import changing file type to Excel browse to the Excel
file then OK it.

Bruce
 
Back
Top