every now and again I have to import a excel files into SQL server. I have noticed that some times that some data ends up being nulls in SQL server but the cell will be filled in on the Excel spread sheet. Some times this is becuse excel has an error such as "number stored as text" when I have some numbers zero filled. I have tried exporting these files to flat text and then importing them to SQL server but I get a problem with quotes showing up in the text fields. so then I imrpot the text file back into excel and then put it into sql server, some meathod does not always work and I seems like to rough way to go any way. Does any one have a solid meathod for importing excel data into SQL server that is quick, easy, and relizable? thanks in advance
Start Free Trial
