July 23, 2009 at 6:41 am
Hi
I am using SQL Server 2008 , trying to load the data from excel files into the sql server table.I have both the type of files i.e .xls (excel 2003 format) and .xlsx (exce 2007).
The situation is i can get any kind of file either .xls or .xlsx files and when i m creating the connection its giving option to create the connection for excel 2007 and which is not loading excel 2003 files...
i hope it is the upgradation and it should work for the both. Any one help will be appriciated as i need it very urgent.
Thank In Advance
July 23, 2009 at 9:40 am
sumankumarreddym (7/23/2009)
HiI am using SQL Server 2008 , trying to load the data from excel files into the sql server table.I have both the type of files i.e .xls (excel 2003 format) and .xlsx (exce 2007).
The situation is i can get any kind of file either .xls or .xlsx files and when i m creating the connection its giving option to create the connection for excel 2007 and which is not loading excel 2003 files...
i hope it is the upgradation and it should work for the both. Any one help will be appriciated as i need it very urgent.
Thank In Advance
Check this post. It will help you to understand how the connectors work.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply