|
Home > Archive > MS Access Database with External Data > August 2005 > Split large Access file into smaller excel files
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Split large Access file into smaller excel files
|
|
| SCOOBYDOO 2005-08-25, 7:25 am |
| 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
| |
| Ronald Roberts 2005-08-25, 1:25 pm |
| SCOOBYDOO wrote:
> 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
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
|
|
|
|
|