Upload .csv via SQL server

Hello All!

I would like to upload a .csv file to a SQL Server database via web interface and Cold Fusion. I would like to ask what the easiest way is for me to accomplish this task.

I’m not sure of the syntax I need to use or whether there is an automated process out there. I don’t know if a SQL Server scheduled job is possible or maybe even a stored procedure. If anyone could just give me any information on this then that would be extremely helpful.

Thanks Guys!

You'd be better off asking that here i think. That's a flash forum, and I don't know a thing about cold fusion.

I'll try that forum too

but does anyone else have an idea?