Saving Excel ranges as database tables
 

I belive you can save/convert Excel spreadsheets to database file formats. Do
you know how?
Many thanks
--
Peter
London, UK

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

"Peter" wrote:

I belive you can save/convert Excel spreadsheets to database file formats. Do
you know how?
Many thanks
--
Peter
London, UK

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



"Peter" wrote:

I belive you can save/convert Excel spreadsheets to database file formats. Do
you know how?
Many thanks
--
Peter
London, UK