Importing *.csv into Access97

[Taliesyn]

Hi! I've got a problem with a csv file from our MRP system. It always contains spaces BEFORE the data in the fields and I need to ignore them when I group the data. The crosstab report works absolutely fine but I don't get the right output because of those darned spaces!!

HELP!!

 

[Bat17]

you could use the Trim() function in a query to remove the spaces.

HTH

Peter

PS. Welcome to the board neighbour

 

[Taliesyn]

SUCCESS!!

Thanks for the tip which worked like a charm! We'll have to get together for a beer sometime. Let's face it, it's not as if there's a huge distance in between and I owe you one, buddy!

Which part of Maidstone are you from? I know my way around fairly well as I've got some good friends in various parts of Maidstone.

Happy Pancake Day!!

 

[Bat17]

Even closer, Harrietsham, but used to live in Ashford.

Peter