Consecutive Delimiters in MS Access XP?

[cclv]

I'm trying to import a large text file into an Acces DB. Everything is seperated with a single space, expect on occasion when one of the fields can have 1 or 2 characters instead of the normal 3. This throws off the columns. Excel has a feature to "Treat consecutive delimiters as one". Is there such a feature or plugin for Access? I'd import the data into Excel except it's too big for the workbooks.

If this isn't possible in Access, does anyone have recommendations?

Thanks!

Jason Dobbs . IT Manager
The Westin Casuarina Las Vegas
jdobbs [at] casuarinacasino [dot] com

http://www.westin.com/lasvegas

 

[dhookom]

Can you open the text file in Word and then search and replace to make the "records" more consistent?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[MichaelRed]

I know of no direct 'feature' in Ms. A., however RegExp could easily accomplish the change.






MichaelRed

 

[cclv]

MichaelRed: Any idea what reghack would take care of this?

Thanks

Jason Dobbs . IT Manager
The Westin Casuarina Las Vegas
jdobbs [at] casuarinacasino [dot] com

http://www.westin.com/lasvegas

 

[cclv]

Sorry MichaelRed, not RegHack, but RegExp. What is it and where can I get it?

Thanks

Jason Dobbs . IT Manager
The Westin Casuarina Las Vegas
jdobbs [at] casuarinacasino [dot] com

http://www.westin.com/lasvegas

 

[dhookom]

Search google for "Regular Expressions".

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[PHV]

Its part of Microsoft Scripting Runtime.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244