| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import from Access??
Hello,
I am using Excel 2003 and have a version of a database created in Access97. Step1: I know that I need to convert this database to the latest version. The Access DB contains a table with over 400,000 rows of information. Excel has only 65000+ rows. Is it possible to import this data from MS Access so that once the first 65000 rows are transferred to Worksheet1, the next 65000 are transferred to Worksheet2 and so on and so forth? The end result would be one Excel workbook with 7 worksheets. Thanks in advance for your help. Ket London (UK) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with data import from Access | Excel Discussion (Misc queries) | |||
| import data from an Access parameter query | Excel Discussion (Misc queries) | |||
| Import records from Access to Excel | Excel Discussion (Misc queries) | |||
| How to import data from a password protected Access DB into Excel. | Excel Discussion (Misc queries) | |||
| Distributing values from rows to columns for Access import | Excel Worksheet Functions | |||
Threaded Mode
