Greetings,
I would like to ask if it is possible to rename the column (A, B, C, D) to
my own customes names (eg: UserID, UserName, etc...)
I would like to use the excel sheet(*.xls) to import data into my database
using DTS(MS SQL Server 2003).
I am a student, and my lecturer said that it is possible to rename the
column and require me to show it but i have tried to browse thru all the
possible menu to do it but to no avail.
Is it really possible??
Your help/advice is very much appreciated!!
Thank you.
I think impossible. You can use (UserID, UserName, etc...) in first row.--
sgm020
------------------------------------------------------------------------
sgm020's Profile: www.excelforum.com/member.php...oamp;userid=26226
View this thread: www.excelforum.com/showthread...hreadid=502022I think what your lecturer meant is that you can change the column formats
from ABC to 123.......that is done by going to Tools/Options/General and
selecting R1C1 reference style.
HTH
JG
quot;ConfusedStudentquot; wrote:
gt; Greetings,
gt;
gt; I would like to ask if it is possible to rename the column (A, B, C, D) to
gt; my own customes names (eg: UserID, UserName, etc...)
gt;
gt; I would like to use the excel sheet(*.xls) to import data into my database
gt; using DTS(MS SQL Server 2003).
gt;
gt; I am a student, and my lecturer said that it is possible to rename the
gt; column and require me to show it but i have tried to browse thru all the
gt; possible menu to do it but to no avail.
gt;
gt; Is it really possible??
gt;
gt; Your help/advice is very much appreciated!!
gt; Thank you.
gt;
- Sep 29 Fri 2006 20:09
Renaming Column
close
全站熱搜
留言列表
發表留言