You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

You might also want to look into the MERGE statement.

You'll probably need to play around with the Access 2010 64-bit driver then, which seems to be the Jet driver replacement.

I haven't had a chance to work with this myself,...

Enclose the keyword in brackets: [Year]

Brandie, I never realized that you hated fellow humans so much... :w00t:

Jeffery Williams (9/29/2010)

---

Wayne,

Thank you so much for your reply. Ok I am not using the OpenDataSource method...

NOW... A simple way to accomplish what I need here (just thinking...

job history. backup history (I think). they add up

(geez, that sounds like you doubted us!)

No problem. Glad to help, and...

Jeffrey,

If you're doing this from a SP, then I assume that you're using the OpenDataSource xp to put the data in?

If so, then you will need to specify the column/row...

You're not using the where clause to not return the rows without commas. This ends up providing a -1 to the LEFT function (which goes to the SUBSTRING function), which...

Ronnie Jones (9/29/2010)

---

Wayne - Thank you for the query. It works great. I plan to research the "FOR XML PATH" statement just to see the use of it. One way...

Whoops, I thought this was a SQL Server question. Sorry about that.

I don't know Access enough to give a suggestion on how to do it from there.

Debbie Edwards (9/29/2010)

---

Hi,

Say I have the following field in a table (1 field there is a comma in the field 'Name')

Name

Support Centres , Miscellaneous SC

Support Centres , Care of tracey...

Either you have an invalid date specification in the insert, or what is there is a different format than what sql is expecting. I see that your date is in...

So you want to break apart this delimited string (with the ; being the delimiter) into separate fields? If I'm understanding this correctly, click here for the latest Delimited Split...