Importing and Exporting

[scottie1]

Hi There

I've got a bit of a nightmare, I've been sent in a CSV file thats got way to much data on it for Excel to handle ie it's got about 200,000 rows on it. I've imported it into access ok thts fine BUT I need to transfer this information into Excel to create seperate files for each customer When I try to import it I run out of memory. I want to avoid the cut and paste method as you all well know this would take for ever. I need to get as much as possible (a multiple of 365)at once in excel as I have a macro to do the rest plus are other system needs it in Excel format,

Please Please Help

 

[lupins46]

Create queries in Access to select specific groups of records and then export the queries.