Christine,
There are a number of ways to do this. With ColdFusion, you might read in
the file in with CFFILE and then use the List functions in CFML to parse out
each row and field.
If it is a one-time import, you might want to look into using Microsoft
Access or Excel to reformat your data and t
Does the insert need to be done in Cold Fusion? What about BCP (for SQL
Server) or SQL Loader (for Oracle)? We usually load the data into "stage"
tables using the load utility from the database and then run stored
procedures to clean the data and insert it into the production database. You
could a
2 matches
Mail list logo
