October 27, 2005 at 10:10 am
I am trying to import an excel sheet into my sql server2000 database table.
I have a column for zip and it has values
07950 and 10925-8999
My database table has a data type varchar(50) for this column and excel sheet has double.
When I try to import these kind of values Its not importing the values like 10925-8999 which has 10 characters(Its just having NULL in databse instead of 10925-8999).
But when I try to change the datatype in excel sheet to text it's converting 07950 as 79050 which is not a required thing.
Can anyone let me know how can i do this import?
Thanks.
October 27, 2005 at 12:44 pm
Uploading from Excel is tricky. I have had some success in uploading to Access first and then to Excel where I have columns that could be character or numeric. Excel/SQL examine the first several rows of data in Excel and decide what the information is.
I have also had some luck in inserting a dummy record with 'text' data into the first row of an Excel spreadsheet and then getting Excel/SQL DTS to upload all the values.
Hopefully someone else has better tricks to get this done!
Michelle
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply