My table is a very simple table, as shown below:

CREATE TABLE [dbo].[sim_PriceData] (

[PriceID] [int] NOT NULL ,

[TimeID] [int] NOT NULL ,

[DataSource] [int] NOT NULL ,

[Price] [float] NULL ,

[MaxPrice] [float] NULL...

DavidBurrows:

Thank you very much for asking for my input file and table definition to try it out. I am happy to send them to you, but I did not see...

spdhiva:

Thank you for your suggestion. As you recommanded, I created a new SQL table and transfer data from the Excel file to this table. Basically there is the same problem....

Thank you, Michael. The truth is that when my query select 1 column, there is one parameter created, if select 2 columns, 2 parameters created. So I don't think the...

buijules:

How do you change the file in a tilde delimite file? Excel does not have the option to save files into this format.

I installed Service Pack 3 in both PCs and it does not solve my problem yet. 🙁

JFB:

I actually looked at this article and did not find the solution for my case. Here are why:

1. I only have SQL Server 2000 installed, don't have a mix environment...

Actually my problem now is narrow to the server machine only (pretty sure my laptop is not relative to this problem), and the problem now seems to be relative to...

What is MDAC? Where should I install it, client or server side?

Yes, all the data are in one sheet.

In fact, some of the data which is missing are text with "," in between the text. In this case, what is the...

Not really. My problem is that not all data in a row are missing. I found that there are more than half of the data is missing, but another half...

The table structure is going to be changed. That is the main reason I need to go over all these mess.

I can manually to generate scripts from the original table...

Antare:

Thank you for the inputs only by just reading my description of the problem.

You are right, the mapping in the transformation is very important. However, even the mapping is...

Sorry, post the wrong format file. Here is the right one:

8.0

5

1 SQLCHAR 2 ...

Just try to change all fields to SQLCHAR, does not work. Here is my new format file:

8.0

5

1 SQLCHAR ...