Import space delimited data to be import into database?

[BennyWong]

Hello All,
I am using Access 2000. I am wondering how can I import data where the data is not formatted as comma delimited format. The data is space delimited as I understand it and each row contains data that I need to import into the database as comma delimited?
Thanks for your advice or suggestion in advance.

 

[Isadore]

Benny: You could open up your text file in code, add the commas, then proceed. My first reaction would be that Access could handle space delimited, but perhaps not as you suggest. You can alway bring the data into Microsoft Word and write a quick loop (Macro) and add the commas (or bring into Excel if Excel accepts space delimited).