March 29, 2012 at 5:59 pm
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.
Thanks,
Tom
March 29, 2012 at 6:10 pm
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.
March 30, 2012 at 1:14 am
sorry but not getting what exact problem you are facing
Raj Acharya
March 30, 2012 at 9:24 am
It's hard to give you any help without more details. For instance, you don't mention how you are copying your Excel file to the database—SSIS, OPENROWSET, etc.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply