Import from Access??

K

Ket

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)
 
D

Dennis

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import multiple excel books to one excel workbook 3
How do I import data into Excel that exceeds 70000 rows? 2
65000 limit 4
How do I make a worksheet have unlimited lines 7
Combine multiple worksheets in one Workbook into one big worksheet 6
How do I increase the limit on the number of import rows in Excel 2
Import Oracle Dbase over 65k rows 4
Unable to import CSV file 2

Top