Importing Data from Excel to Access

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

Guest

I have a spreadsheet in Excel that I want to make into a database in Access.
Is there a way, and if so how do I import Excel data into Access 2003?

Thanks

David
 
File
Get External Data
Import
Change file time to 'Spreadsheet xls'

follow the instructions..

Ron
 
File
Get External Data
Import
Change file type to 'Spreadsheet xls'

follow the instructions..

Ron
 
THanks. I am a little slow. I finally found the instructions after
searching the help menus long after I sent the question.

Thanks
 
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
Import data from Access to Excel containing VB code 3
How can I push Access Data into Excel from Access 2007? 2
Import Excel comments to field in Access 1
Excel Data Transfer Issue (strange situation) 1
check excel before importing 4
Import to many to many table 7
Import Excel Spreadsheet 1

Back
Top