hi Pete,

On 14.04.2010 17:08, ChicagoPete wrote:
The raw file size is 500,000kb.
This may result in size problems.

How do I split one table into several (either in Access or SQL) after import?
You have to do it manually.

Create the necessary tables as you can entities in your file.
Then create appropriate append queries.

I would like to stay totally in Access 2007, more comfortable...
You can link the SQL Server tables into Access and do the data
processing (splitting the data) in Access.

Sorry for being so vague, but as I don't know the data the explanation
has to be so abstract.


mfG
-- stefan --