Tab Delimited Imports

[SandyDandy]

Hi,

I am trying to import a tab delimited file containing 300,000+ rows to a new table in Access 2003. As I need to split one of the fields, I use the 'Fixed Width' option in the import text wizard. When I do this, I find that the column breaks I insert jump around as I scroll right to add the last few.



This means that when I import the data, the columns are never as I actually set them and require them so the data is useless. I have tried counting the cells etc but this doesn't work.

Any suggestions would be greatly appreciated...

Thanks,
Paul

[thhui]

Import the tab-separated text first.
Then you can split the field after the import by running the query later.