"I feel your pain about Excel imports. If Excel and SQL Server weren't both MS products, I could understand the mismatches being a problem. MS clearly intended Excel to be...

Dinesh

Your example is interesting. Do you want to use Excel as

an order entry form? In that case you have to secure that

the user doesn't insert incorrect data. That can be...

Thank you Dinesh.

If it comes to read individual cells I think it is much easier to use Excel,

VBA, ADO and SQL . I do have of code examples if anybody...

Pablo

ahhh... you check against target table, that's cheating Gosta!

I like Ramoncito's magic process the more

I would also like to see the magic process:-)

but I am no...

Ramonicto

You provide very lite information about the texfiles and how your VB program works.

But if you like to use VB use it.

I use VB6 and now VB2008.net and ADO.net to...

" I need to implement a solution to programmatically load data from a password protected .xls file into a SQL database table. "

Have you considered to use VBA and ADO...

I almost killed my brain by trying to import Excel files in .xls format.

As Phil says. Use CVS or TAB separted format. Make a small makro in the Excel application.

Then...

In a situation like this I would use Phils approach

with bulk insert in one staging table one field and then

pars data with substring functions to extract the different fields to...

Load test on PowerPivot. (Project Gemini)

I have downloaded the 32 version of Excel 2010 Beta and PowerPivot.

To be short. Working with tables like an invoice table with 10 keyfields and...

Be aware

"Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 4GB of user...

"I need to do it with T-SQL because my customers first upload a XLS, then press a button that loads the data in a SQL Table."

If it is possible to...

Nuts,

One option is to save the Aceess database as a 2000 compatible database .mdb format.

Another workaround is to use the DTS Feature Pack for MS SQL Server 2005.

http://www.microsoft.com/downloads/details.aspx?FamilyID=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en

Then...

"We have a nightly job that inserts a couple of hundred thousand rows in to a table. There are 4 indexes on the table and the operation is quite slow."

What...

"I have a VB6 program working with a SQL Server database on a LAN

Can I connect to the database if loaded on a web server"

If you with web server mean...

"How do i achieve it thru SSIS or thru DTSWizard?"

I have a humble question.

Must you use etc?

I would recommend you to save the Excelfile as as a TAB separated text...