You're getting the errors because the temp tables already exist. I can see the lines further up where they are supposed to be dropped, but they are remarked, so...

I forgot to add that pietlinden wasn't talking about using SSIS. If you have linked tables you won't need SSIS. It's very useful but has a bit of...

A linked table in Access is a table object which doesn't reside in Access, but exists somewhere else and is linked to the Access table objects. It sounds complicated...

Take a look at 'sp_columns' (for tables) and 'sp_sproc_columns' (for stored procedures) in BOL. Both are system stored procedures and they might be what...

Have you tried opening the 2000 d/b with Access 2013? It might just convert the old format automatically although I'm not sure if the later version will go that...

@mark-3 Cowne

+10

Very elegant solution.

Offshore developers...whaddya gonna do? :Whistling:

I always say yes when the boss is handing out free training. It may not be immediately applicable but learning new things is always a good thing. Keeps...

No we don't do code reviews in a formal sense. These days the excuse is 'not enough time' but I think that's shortsighted. I have learned the...

What kind of an alert do you want? An email would be great here, but the message is that you can't send an email due to lack of...

Search the forums for 'interview questions' or 'interviewing'.'

I know I've seen several discussions of this over the years.

Patrick Cahill (4/23/2015)

I couldn't disagree more. Our developers are...

Not much to go on, but ...

If you run this:

SELECT * FROM OPENROWSET(BULK N''' + @fullPath + ''', SINGLE_BLOB) AS x

Does it run silently or do you get an error?

If...

Go to Books Online and read up on the DatePart, DateDiff and DateAdd functions and how to use them to take apart DATETIME columns.

Also look at Lynn Pettis' ...

You'll need to write an INSERT trigger on the Stage table. Any time a record is inserted into a table, there is a system recordset called INSERTED that is...