We need a piece of software to be created to import information from excel to SQL. The information is in 6 different fields and must be formated to meet the requirements for barcodes in our SQL server. The information includes date of production, weight, serial number, product ID. This must be inserted into SQL in the right format so barcode readers will be able to read the barcodes. It also must create a report of all items entered into SQL and any mismatches found and errors. The winning bidder will recieve a copy of the database along with a copy of the excel sheet. This must be easy to use without issues. Payment will be placed with Freelancer and released ONLY ON COMPLETION. NO PRE PAYMENTS will be given.
36 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
I have extensive experience with both Excel and SQL and and have worked with almost all of the various barcode types. Please contact me if you wish to discuss further.
I have big experience as Senior Database Developer. Expert in MS SQL. I many time import data from different formats like: csv, xls, xml etc. I can make stored procedure for import data from excel file.
What kind of barcode reader s/w are you using and the reports is something for the same software or are you looking at an excel report? Looks like an interesting project. Please ping if you think I can fix this. Thanks