I am trying to copy an excel file to my table. I have 2 tables (Cert and Cert$). If I use Cert$, it will allow me to run the copy immediately. If I try to use Cert, it will not.
I can get it to run immediately by renaming the Cert$ to something like Cert2 and rename Cert to Cert$. Now it works fine.
It also gives me an error on my DateTime file saying that it failed because of a potential loss of data. it has the word NULL in it and is a nullable field. Do I need to put something else in the field to make it null? I don't want it to be blank.
I have tried everything to get this and another file to work and in that one I am getting the same type of error for a column that is blank.
This is 2008 R2 Management Studio running against an 2005 database. This is one of the worst program I have used. This should be easy and the data is not complicated.
Thanks,
Tom
I can get it to run immediately by renaming the Cert$ to something like Cert2 and rename Cert to Cert$. Now it works fine.
It also gives me an error on my DateTime file saying that it failed because of a potential loss of data. it has the word NULL in it and is a nullable field. Do I need to put something else in the field to make it null? I don't want it to be blank.
I have tried everything to get this and another file to work and in that one I am getting the same type of error for a column that is blank.
This is 2008 R2 Management Studio running against an 2005 database. This is one of the worst program I have used. This should be easy and the data is not complicated.
Thanks,
Tom
