Hi everybody,
I have 1 to n Excel spreadsheets I need to load to SQL tables. Excel
files names are table names in database and Excel column names are
table columns. I need to check if table exists in db, rename existing
one to name_bak, create a new table and insert data into it from Excel.
I have to do it for all files in a specified directory. Does anybody
have an example of creating dynamic mapping of Excel to the dynamically
created destination table? Any help is greatly appreciated.

Hello pomarina,

I am reading this list of posts the wrong way around and saw this post after
I saw the other post. Same still applies though ping me if you want a look
at something I built.

Allan

Allan i am interested in what you have pertaining to reading data from an
excel spreadsheet into a sql table

Thanks,
danny

Hello Daniel,

In what way? Are you referring to the issues that Todd and I were working
through?

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com