I agree with Mike.

I banged my head with SSIS and decided not to use SSIS at all together with Excel.

(of course you can save as a textfile etc but then...

I would make a small macro in Excel which will format the cell.

Selection.NumberFormat = "0.00%"

/Gosta

Can you consider using VBA?

Regards

Gosta

Dear "Dog"

I usually use ODBC and ADO or OLE-DB and ADO as connections with VBA.

How do you specify a connection?

//Gosta

Try:

http://peach.ease.lsoft.com/archives/excel-l.html

I have been working a lot with Excel and SQL connections.

But it will be hard to help you to wind up spagetticode without

the code and possibilties to test it in...

Ram

I have no problems to import textfiles with Gbyte size using bulk insert.

You have to give us more details about your set up.

/Gosta

"No, We cannt read PDF data into SSIS."

You can convert the PDF file to a textfile and then use SSIS

I don't use SSIS but VB.net. My tip is to create...

I dont know how to do it in SSIS but I do have the same issue.

A bunch of textfiles sent by FTP to be imported to a database (daily).

To each...

I can do that for you. I use VBA, ADO and T-SQL.

I will not put any code here because it is more than a "small work"

to create and test the...

A little warning.

You might run into slow respons time. I hope not.

Google for something like "join linked server slow response".

In one case I found out it was better to...

Ken

If you don't want to distribute the Excelfiles with any macro you can create

the Excelfiles on a server (with an auto open macro which runs frequently enough to refresh the...

Ken

Have you consider to do it the other way around? In short.

What I do is to create an Excel template with a build in "macro"

VBA code. This template is available...

Is it possible for you to save the Excel files as TAB separated textfiles instead?

I generally try to avoid importing native Excel files because of the problems you

others report.

I put...

As GilaMonster says:

File IO and file system operations are not T-SQL's strong points.

I suppose you also want to logg what is happening and send messages.

Why not continue to use C#...

Grahamn

"and contains macro's causing it to be a .xlsm file."

As you already use a macro why not save the file as a TAB separeted text file etc.txt

and use SSIS or...