Saving Excel ranges as database tables

P

Peter

I belive you can save/convert Excel spreadsheets to database file formats. Do
you know how?
Many thanks
 
P

PeterAtherton

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
 
C

CLR

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
 
Top