Have a look at this thread and the issues i had importing from Excel 2007 on 64 bit

http://www.sqlservercentral.com/Forums/Topic1275171-391-1.aspx#bm1281939

I suppose you could say does it really matter? its all down to how you decide your data is to be structured. I have many databases on 1 instance and...

There is also a report that you can run on the database, open ssms, navigate to your database, RMC and selct reports, General reports, schema changes.

Have you run a profiler trace on this when your trying to update your DB?

Looks like you have duplicated this thread

I think the first thing to ask is are you using the correct join? do expect that all the records in the Mail table will have a corresponding row in...

Ignor comment just re looked at your query, what exactly do you expect the reslult to be?

What shold the question marks be do you know? should they be chinese characters? if so on the columns where the data is ? what is the datatype of these...

Well i never managed to get the issue fixed with 64 bit pc having a 32 bit office but it did work on windows XP :), here is script...

you can always use patindex to do the same.

select * from your table

where PATINDEX('%[^a-z,0-9]%',yourcollumm)>0

Can you supply DDL tables and respresentative data, search this forum for how to request help and i will have a look at what you ask

HI Randy,

Thank you for your help, identifying a file name is the easy bit and that bit of my script works fine, renaming the file i can do too...

Can you provide some dummy data and how you would like the results to look 🙂 thanks, from what i read of your post to me sounds like you would...

no need to shout, no i do not look at the dates in the post, it appeard as a topic entered in the last 24 hours therefore are current posts

Like other people suggest i would approach this using a pivot table, why does you boss object to a using pivot?