| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
| Opening and saving Excel 2003 file from Excel 97. | Excel Discussion (Misc queries) | |||
| How do I save a record from an excel template to a database in a . | Excel Discussion (Misc queries) | |||
| Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) | |||
Hybrid Mode
