Saving Excel ranges as database tables

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

Guest

I belive you can save/convert Excel spreadsheets to database file formats. Do
you know how?
Many thanks
 
You can save the active sheet as a dbf file. File|SaveAs|Type db1,db2 or db3.

Then in Access you can open up this file (I've Just doneit).

But I think that you can open Excel files directly in Access but I'm not
sure about choosing the data sheet. Why not just try it and see.

Regards
Peter
 
You can import either Excel Sheets, or NamedRanges into Access as tables.

File > Get External Data > Import.....and follow the menus......

Vaya con Dios,
Chuck, CABGx3
 
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

Saving Excel 07 as .WK4 1
What are the steps to fix damaged MDF files in SQL Server? 0
How to Convert MBOX to PST Online? 3
How can I migrate MBOX to PST? 2
How can we convert OST to PDF file format? 1
How to Export Gmail Emails to PST Format? 4
Excel And Notepad 3
Which is the best MBOX Converter Tool different formats conversion? 4

Back
Top