471,076 Members | 911 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,076 software developers and data experts.

importing excel sheet having "Date" in Column names

Hi All,

I am new to MS SQL , when I import an excel file that contains "Dates" in its column names to MS SQL 2008, the date is not displayed in column name in MS SQL. Rather it shows F3, F4, F5. I have even tried to change the data format to "date". The excel is like

KPI Target_valye 25-May-2010 26-May-2010 ......

Kindly suggest your expert opinion.
Regards,
Awais Mushtaq
Jul 4 '10 #1
1 1614
ck9663
2,878 Expert 2GB
Did all the column changed to F1, F2, F3, F4...? or just that one column? You should specify that your file has a header row.

Good Luck!!!

~~ CK
Jul 7 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Westcoast Sheri | last post: by
11 posts views Thread by walterbyrd | last post: by
3 posts views Thread by davidfinance | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.