I am having a table available in excel format and features the following:
- It has about 170000 rows
- Some text is in Arabic (e.g. UTF-8 encoding)
- Some text is longer than 255 in length.
I used the already available Import from Excel to MSSQL Table available in SQL Server but it always trims the text if it is more than 255 chars in length.
I am looking for a solution to import the excel data fully without any chars trimming etc. Bidder might propose developing a simple program for this, or any other feasible solution.
Attached is a sample excel file
85 freelancers are bidding on average $116 for this job
I have also made a tool like this for two databases. i can share the screenshots with you.i can modify it for excel. characters greater than 255 length will also be moved.
Hello, I have experience in EXCEL to MSSQL Conversion. i want to discuss with you project detail. my program will work without MS Office. thanks Kalpesh
Dear Sir, I can do it right now. I will write a store procedure to import your data to MS SQL server will all information in your excel file. Best regards Thanh
Hello, I can start right now, I will use better column type for long string which version is sql server? I can create a c# application that import excell data to sqlserver Regards Hakan Yurt
Hi there. I am senior developer from Vietnam. I have been working on this site for 2 years. I am interested in your [url removed, login to view] let's me help you.
Hello, What is your SQL Server version. I have multiple options to do this. Can you please share your table schema also. I will try importing and let you know the easiest solution on success. Thanks
I am an expert .NET developer with more than 9 years of experience. I can develop a small app for you to import that excel file to ms sql table. Please see my profile and consider my bid.
hello I am c# developer. I will create desktop application that will convert your xlx to sql datatable I am c# developer having 5 year experience. thank you [url removed, login to view] is my Skype