Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Importing a text file with changable format

Author  Topic  oalmog Starting Member 1 Post Posted - 2009-11-17 : 12:10:02 Hi all, I need to import a text (CSV) file into a table in SQL on a daily basis, but here is the catch: The file might have different format (different number of columns) everyday, i.e. might have different number of columns. Now, I don't want to import the existing columns and in the rest have null, I want it to create a new table (with the same name) but with the number of columns in the text file for that day. Hope I was clear enough. Thanks for the help!!!