Woohoo!

Looks like I was able to fix a couple of minor typos and get it working. Thanks very much again for your help. You've no idea what a relief it...

Thanks, that helped. I also had to edit the fact that it was iterating the @id twice (so was only insertint 77 records when I added your fix for the...

Isn't there a tsql option to make this possible though? This is a totally server side run setup. No VB programming, only sp's and DTS, etc.

Or is it impossible...

It took me a bit to figure this one out, and I still don't know a faster way to handle it. It's apparent that the connection for the file remains...

Additional information:

Import of AlphaByMarket causes the 12,000+ null records.

However, AlphaByState and AllAreaCodes work correctly.

In looking further, it appears the client had for whatever reason over 12,000 empty

entries in the first...

Hmm, it imported, but it added about 12,000 (NULL) rows (there were only about a 100 in the sheet). Any ideas why it would do that?

Thanks.

I tried it with the other sheet names:

AlphaByState

AlphaByMarket

AllAreaCodes

And that fixed it. I had posted these sheet names earlier, so thought you were indicating the filename again.

I guess I should...

Hmm, that's didn't seem to help either... Different error:

SELECT * INTO MarketsPreTemp

FROM OpenRowSet('MSDASQL', 'Driver={Microsoft Excel Driver (*.xls)};

DBQ=C:\MarketsImport\Markets.xls;

DriverID=790;',

'SELECT * FROM [Markets$]')

Results:

Server: Msg 7399, Level 16, State 1, Line 1

OLE DB...

Hmm, That still doesn't seem to work.

There are three worksheets in the Markets.xls file

AlphaByState

AlphaByMarket

AllAreaCodes

Btw, they originally had spaces in the names, and I removed the spaces to "play it safe",...

Ah. That could be it then, I thought it was dependent on the filename.

I'll get back on that, but I suspect that would be it. Thanks!

Yes, the file is on the same server. I've imported DBASEIV files using similar syntax and locations on the same system.

Excuse me for a second while I..

JUMP UP AND DANCE A JIG!!!  😉

That did the trick. Thank you ever so much.

Here's the combined code:

/* Need the intersection of column names...

I'm sorry, I'm so tired and bleary eyed (and almost out of time on this stage of the project), I'm probably overlooking something obvious like renaming a variable?

Hmmm. Well. Regarding the dynamic columns:

it runs now without any errors, and imports the dbf file into Project01PreTemp (as it did originally), and no errors, but nothing is actually...

Yes I'll improve as best I can. 😉

But it's great to have a clearer idea of how to handle it.

I'll first make sure the dynamic columns issue works with a...