importing text files

[DotNetDunce]

I'm pretty new at this. Is it possible to use ColdFusion to import a text file into Access 2000? If so, can someone point me to an example or tell me where to start?

Thanks.

 

[iqof188]

One thing you can do is use the textfile as a datasource. With CFHTTP you can use a textfile as datasource. Just provide a name (this will be the query name), a delimiter for the columns, a textqualifier which indicated where one row starts and ends, and the names of the columns in a comma-delimted list. Also make sure you set the method to "GET". Once you have your recordset, do an insert on your access DB for each row by doing a CFOUTPUT QUERY. Hope this will help you get started.

<webguru>iqof188</webguru>

 

[tleish]

A good tutorial for parsing through a text is:

http://www.cfvault.com/index.cfm/mo...41-EC08-11D3-85030050DABEAE1B/Tutorial_Page/1

- tleish

 

[DotNetDunce]

This has been wonderful help. Thank you very much. I have one more problem. I've managed to use cfhttp to get my data and have successfully inserted it into the access table, but it's skipping the first record. Any clues as to why?

Thanks again!

 

[DotNetDunce]

Nevermind......I found out why. CFHTTP ignores the first line if the file doesn't contain column headers in case anyone else is wondering.