Copy link to clipboard
Copied
Hi i need to know how to upload text file in to database using coldfusion and the file does not have any column names. Can anyone help me in this.
The sample of data in file is:
00012009032216001111039289000005.9900100000000000000.00
Copy link to clipboard
Copied
You can start by using list functions. After uploading and reading the file, you can treat the resulting variable as a list delimited by chr(10) & chr(13). As far as processing each line goes, you have to know it's structure.