Hi All,

I have an Excel sheet which I recieve every week. Its not too much data
and the present process is to manually load that data into a SQL Server
2000 EE table.
But I would like to automate this process. I have tried using the
DTS, but it doesn't work. What I wud basically need is that a cell in
the Excel sheet could be loaded into a particular column. So suppose,
A12 goes into a column named Amount. There are around 10 columns in
the table.

Is a way to do that??

Thanks,
RIcky

--
Posted via http://dbforums.com

If I understand correctly, once the package is defined,
you can alter the transformation to assign the Excel
column to any field on the destination table. You can even
load part of the data source to different columns.

Is that what you mean?

What do you mean ut doesn't work ?
What errors do you have ?

Are you trying to insert individual cells of data into SQL Server ? (Can be
done but time consuming)
Do you just have columns fully populated that you want to insert into SQL
Server ?

Bit unsure as to what you need

--


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

"Ricky_Singh" <member32195 (AT) dbforums (DOT) com> wrote

Did you ever get an answer for this? I have the exact same issue.....


--
Posted via http://dbforums.com