Using Select With Excel

#1

Hi,
I have a statement Like this
SELECT F29,CR,F35,F36,F37,Left(F38,200) AS F38,F39,F40
FROM SHEET1$

It parses fine and maps fine but when I execute is says
source for F38 Unknown .. But If I remove IMEX=1 It
Executes Fine
Why?
Thanks Ravi

#2

Hi Allan
I tried it out with a different Excel it works , But my
current Excel is giving me problems.
Can I send you the excel for you to take a look ?
Thanks
Ravi

Quote:

-----Original Message-----
Seeing as I do not have your sheet here is what I did

1. Add an Excel and SQL Server connection
2. In the extended properties of the Excel Conenction
added IMEX=1
3. The Excel file has ~45 columns
4. Created my datapump -
SELECT A, a1, a10, a3, a4, LEFT(y, 2) AS BBB
FROM
[Sheet1$]
5. Mapped the fields
6. It succeeded.

--

----------------------------
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

"Ravi" <rravi3 (AT) Covansys (DOT) com> wrote in message
news:017301c36221$b14b97f0$a001280a (AT) phx (DOT) gbl...
Hi,
I have a statement Like this
SELECT F29,CR,F35,F36,F37,Left(F38,200) AS F38,F39,F40
FROM SHEET1$

It parses fine and maps fine but when I execute is says
source for F38 Unknown .. But If I remove IMEX=1 It
Executes Fine
Why?
Thanks Ravi

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Using Select With Excel

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Using Select With Excel - 08-14-2003 , 12:05 AM

Re: Using Select With Excel - 08-14-2003 , 04:29 AM