MS Access Database with External Data

Author

CSV file import

Mat

2006-04-02, 7:29 am

Hello

I have managed to import a CSV file into a string but Im wondering if
there is an easy way to extract this string to seperate variables for
processing. The CSV file is comma delimited and only containes one
frcord of about 15 fields.

Thanks in advance

Mat

Douglas J. Steele

2006-04-02, 7:29 am

Take a look at the Split function.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"Mat" < coyoteservices@gmail
.com> wrote in message
news:1143971475.177312.22410@j33g2000cwa.googlegroups.com...
> Hello
>
> I have managed to import a CSV file into a string but Im wondering if
> there is an easy way to extract this string to seperate variables for
> processing. The CSV file is comma delimited and only containes one
> frcord of about 15 fields.
>
> Thanks in advance
>
> Mat
>

Mat

2006-04-02, 8:29 pm

Fantastic

Thank you very much!

Mat

Sponsored Links