Importing an excel spreadsheet in to access

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

Guest

Can anyone advise on how I can import and excel
spreadsheet in to an access database? Any information
would be helpful
 
Access can link to as well as import Excel data. Which have you tried?
 
With your database open and objects menu open, click on File|Get External Data|Import. The column headings in Excel must be exactly as your field names if you want to add to an existing table.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
query is not updatable;; urgent 1
Importing hyperlinks from Excel 3
Access Subscript out of range when importing into access 2010 from excel 0
Excel Access - importing an excel spreadsheet 0
Microsoft Works to Microsoft Office 6
Excel Excel spreadsheets opening at top instead of bottom. 4
Importing Excel spreadsheet into Access 2010 0

Back
Top