Split large Access file into smaller excel files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have a large dat file which I have saved as an Access file. I have
sorted the file into alpha and now need to split this access file into 8
seperate excel files.

I would prefer to split the file by specifying the row numbers, however, any
assistance would be appreciated.

Many thanks
 
SCOOBYDOO said:
Hi, I have a large dat file which I have saved as an Access file. I have
sorted the file into alpha and now need to split this access file into 8
seperate excel files.

I would prefer to split the file by specifying the row numbers, however, any
assistance would be appreciated.

Many thanks
Click to expand...

Not sure what you mean by:
"dat file which I have saved as an Access file"

Did you import the data or write a routine to read the data into
a table with data in seperate fields or is the data in 1 field?

Something in the data is telling you how to split the file by row
number. Use this field as the criteria for a query to select each group
and then export the query to an Excel file.


Ron
 
Back
Top