close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()