Split large Access file into smaller excel files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SCOOBYDOO - 25 Aug 2005 10:39 GMT

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

Reply to this Message

Ronald Roberts - 25 Aug 2005 17:58 GMT

> 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
[quoted text clipped - 4 lines]
>
> Many thanks

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

Reply to this Message