Hmm... Problem persists... even the test comes back as ÀAlbèert ËEîinSsStêeiìn ÌInstìitúutëe

I found the problem... I didn't need the word VALUES or the parentheses.

I'm not following the placing of the literal amounts into the SQL. Shouldn't I just be using field names/:

SELECT 100.00, 54215 UNION ALL

SELECT 125.00, 53252 UNION ALL

SELECT 110.00, 63225 UNION...

I went through the GUI with it failing the 'test connection'. I'm trying to put together some code in VBA/Access that I could use to push the data when someone...

It gives me an error that there are too many parameters.

Could I use something like this? There is no formal security on the database, just the folder in which it...

I used the 'Microsoft.Jet.OLEDB.4.0', and redid the addlinkserver:

EXEC sp_addlinkedserver

@server = 'GCDF'

,@provider = 'Microsoft.Jet.OLEDB.4.0'

,@datasrc = '\\denalibcc\databases\GCDF\BE\GCDF_Web_Master.mdb'

,@srvproduct='Access'

GO

I'm confused with the below, should I be looking at the security on the...

UPDATE [CPCE_DB].[dbo].[Orders]

SET [OrderDateAlt] = CAST([AdminDateID] AS Datetime);

gives: Msg 241, Level 16, State 1, Line 1

Conversion failed when converting datetime from character string.

getting an error: Msg 173, Level 15, State 1, Line 1

The definition for column 'OrderDateAlt' must include a data type.

ALTER TABLE [CPCE_DB].[dbo].[Orders] ADD [OrderDateAlt] (DATETIME);

or ALTER TABLE [CPCE_DB].[dbo].[Orders] ADD...

Something like this?:

INSERT INTO [CPCE_DB].[dbo].[Orders].[OrderDateAlt]

SELECT Cast[AdminDateID] AS Datetime

FROM [CPCE_DB].[dbo].[Orders]

Actually I put the wrong exam numbers in to test... your solution worked great and I learned some valuable information... Thanks!!

I changed to the next field needing updated 'contentScore2'

I ran the code you suggested:

SELECT *

FROM [PearsonScores].[dbo].ViewScoresView s

INNER JOIN [HSBCP_DB].[dbo].[ExamInfo] e ON SUBSTRING( s.testID, 3, 4) = e.testID

and I...

I used the below and got no error in the Sp creation or execution but the field did not update, any places to look?:

Thanks!

USE [PearsonScores]

GO

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE...

Yes thanks for the tips on several points... I got the same results so my initial query wasn't that bad... but I did discover that the data in general was...

Hope this is what is needed:

USE [HSBCPcopy_DB]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[certs](

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

[peopleId] [int] NULL,

[statusID] [int] NULL,

[certificationExpireDate] [datetime] NULL,

CONSTRAINT [PK_certs] PRIMARY KEY CLUSTERED...

Hope this helps as far as DDL and what the data looks like:

CREATE TABLE [dbo].[Billing](

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

[peopleId] [int] NULL,

[chargeamount] [money] NULL,

[billMonth] [int] NULL,

[billYear] [int] NULL,

CONSTRAINT [PK_Billing1st] PRIMARY KEY...