Sharing data between Excel and Access

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

Guest

I have my original data in excel format. Can I convert the data in Excel to
Access as the data base in Access? I know how to export data from Access to
Excel, but do not know the reverse. Can somebody answer my question?

Thank you,
Linda
 
Linda

You can either Import it or Link the Excel table (the latter will always
have the up to date data from the Excel worksheet

In Access go to File>External data> and select import or link. (Be sure to
select Excel from the 'files of type' dropdown in the dialog)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
 
hi
and to add to Nick's suggestion, make sure you declare you xl data a named
range. this make for a cleaner import/link. and as Nick pointed out, linking
give up to the minute data and it is a little silly to store the same data in
two different places.

Regards
FSt1
 

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
Exporting selected data from Access to Excel 1
Access #Error & Excel Pivot 0
Exporting Data From Excel to SQL 1
Merging data of the same record 1
Deleting blank rows 4
CSV->Excel Data Problem 1
Opening excel 2010 spreadsheet from Access 4

Back
Top