Table manipulation using VBA

[PISCES]

Hi Group,
I've used a import specification to import a Fixed-width file. However because of the layout of the initial file, i.e the fields' header starts BEFORE the fields data, I need to do some manipulation to get rid of the extra space in each row.

How can I loop through each record of the table to get rid of this extra space. Is there a a special character I can use for a space?

Kind Regards

 

[namliam]

If its a fixed width you can specify that you dont want to import more than the values in the textfiles...

No need to take into account the headers, however you will need to delete the (partialy imported) headers (and/or footers).

Regards

 

[fpendino]

I tend to have this problem with some of the data I import also. I use the Trim() function within a query to help eliminate the coding part of it. I believe Trim only gets rid of the spaces in the front part of the field. To use this properly though, when importing, I have an import table that I bring the data into in whatever format it is and then use an append query to make all of my justifications, like using the TRIM() function. Hope this helps.