Just create the table in access and then use CF to read the file contents and insert the data into the table. If it is a single column, is the first row a column name and the rest the data for that column?
Douglas Brown Email: [EMAIL PROTECTED] ----- Original Message ----- From: "Kola Oyedeji" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, August 03, 2002 11:13 AM Subject: RE: SSL on form submission > Hi > > here is my problem i have a text file with a single column which i would > like to get into an access database (i know i know). Now I know > i can use dts to import the data into sql server but from there can i import > the data/table into access? > > Thanks > > Kola > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
