Hello All,

Could anybody advise on the following ?

We have a situation where we need to import an Excel file into a SQL Server
table. Before we import the file, we would like to validate it by checking
the number of columns that exist in the Excel file (columns with data only).

Have you ever done something like this? Could you suggest the easiest way to
do this?

Thank you.



Regards, Brian.

So you do not know how many columns of data you have up front ?

You can do this

Create a linked server of the Excel spreadsheet

Use a SELECT INTO to load it into a working table

Use a COUNT(*) from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'Your
Working Table'



--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Brian" <brian.perks (AT) investecmail (DOT) com> wrote