So, I am a bit confused.

My data is putting out a lot of decimal places when I really would like to have this in money format. My table is showing...

I know. I'm sorry. I apologize This is the second time I have ever done SQL coding so I'm...

That's what thought I did. I double checked and it went through easily. Updated the 261 records. Awesome!

Thanks Wayne and Craig for your help and patience. This is my first...

I bet I've messed up the code then because I changed a lot of the survey's to TestTable and...

Craig Farrell (9/2/2010)

---

Please post the FROM clauses, it sounds like the old version of:

FROM dbo.TestTable survey

JOIN dbo.[Sheet1$] xl

...

Line 15 had an extra comma so that resolved Line 16's error.

Now I'm getting a Msg 4104 on line 27, "The multi-part identifier "TestTable.ID" could not be bound." This error...

I've resolved Line 32.

I still don't see what is wrong with Line 16???

Except that I receiving some errors.

On Line 16, which is FROM dbo.TestTable it...

Awesome, I have the test table set up. I've updated the code and receive this error. I'm sure it is my fault but I could use some guidance on resolving...

There are over 6800 records in the database, will this code cause any problems with the other records?

How can I copy this table and test on it?

Thank you for your patience Wayne.

Primary Table, meaning this is where we want the imported data to go.

CREATE TABLE [dbo].[2010 Master Survey Results](

[ID] [int] IDENTITY(1,1) NOT NULL,

[BENCHMARK] [float] NULL,

[YOUR_STATES_JOB_TITLE] [nvarchar](255)...

WayneS (9/2/2010)

---

mfowler12 (9/2/2010)

---

I was able to import the data by using the DTSWizard. It was on a different drive.

So, how do I link the tables so that the data can...

I was able to import the data by using the DTSWizard. It was on a different drive.

So, how do I link the tables so that the data can be transferred/updated?

I'm...

WayneS (9/1/2010)

---

Probably the easiest way would be for you to use the import wizard (right-click the database | Tasks | Import data). For the data source, select "Excel Source", and...