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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import from Access??
Yes it can be done. That said, depending upon what you wish to do with
the data in XL, you may find that XL is very slow. XL places everything into memory. Suggestion, attempt to use Access for serious database work as opposed to XL. What type of things do you wish to do with the data? Dennis Ket wrote: 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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import from Access??
Ket,
Follow this link: http://support.microsoft.com/default...;EN-US;q120596 Dennis Ket wrote: 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) |
Reply |
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 |