Excel to Access

J

jess

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.
 
K

Ken Snell [MVP]

Do it from ACCESS. Are you doing it manually or do you need it to work from
programming?
 
S

SacCourt

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.
 
B

Bruce

In Tables select New/Import changing file type to Excel browse to the Excel
file then OK it.

Bruce
 
Top