Importing from a database into a workbook

[ocalader]

I have a workbook that has 13 or 14 sheets that would be populated by with data from a large database. Each sheet would have to be sorted, counted, possibly grouped and then charted. I have a master database that contains about 10 million records that would be selected for various results to be imported into excel. I It was done about 20 years ago using foxpro as the database, I can use the new version of foxpro or access. Any suggestions?

[Logit]

Keep in mind the Excel only allows 1,048,576 rows of data.

Not certain how your data is laid out but this might be of concern and possibly direct you to another piece of software, unless there is a means to 'break down' your 10 million records into smaller groups.