Sync Excel With SQL Server Table using Microsoft Access

Lezárva Kiadva: May 23, 2010 Kiszállításkor fizetve
Lezárva Kiszállításkor fizetve

I have an Access 2003 Data Project that connects to a SQL Server 2005 Database. I need to synchronize a table in the SQL Server 2005 database with an Excel 2003 or 2007 spreadsheet. I have written the logic to determine which records to insert/update/delete from the database based on the data in the Excel spreadsheet. It functions properly. I have 3 problems/needs: 1.) I can read the data from the Excel spreadsheet into a temporary table using the OPENROWSET command of SQL Server. However, any columns that have more than 255 characters get truncated to 255 characters. I need all of the characters...sometimes as many as 1500...from the column. 2.) 2 of the columns in the the Excel spreadsheet contain HTML code. This doesn't display properly in the Excel spreadsheet nor does all of it import into the database. I have compared the length of the imported data with the original and when it is different...it is different by 2 or 3 characters of a 1400-1500 character field. I need to know what the character is so that we can remove it. 3.) Finally, I would like the project (ADP using Forms and Macroso) enhanced just a little to allow the user to export the data to an Excel spreadsheet, make changes to it and save the file, then click to import it, let the app show them the changes to be made (I have this logic in there), then ask them to accept the changes and apply to the database. RIght now they have to click a second button to save the changes to the database. I would also like proper error handling in the project to capture any errors and respond appropriately.

## Deliverables

1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the worker's Worker Legal Agreement).

## Platform

SQL Server 2005 database Excel 2003 or 2007 spreadsheet Access 2003 or 2007 Access Data Project

Microsoft Access MySQL SQL

Projektazonosító: #3448678

A projektről

6 ajánlat Távolról teljesíthető projekt Utoljára aktív: Jun 2, 2010

6 szabadúszó tett átlagosan 62$ összegű árajánlatot erre a munkára

amcsummers

See private message.

$85 USD 1 napon belül
(50 vélemény)
5.2
hoangvandungbk

See private message.

$55.25 USD 1 napon belül
(9 vélemény)
3.8
happydotnet

See private message.

$63.75 USD 1 napon belül
(5 vélemény)
1.9
ayashachen

See private message.

$59.5 USD 1 napon belül
(5 vélemény)
1.7
graycellsvw

See private message.

$42.5 USD 1 napon belül
(0 vélemény)
0.0
harisahmedvw

See private message.

$63.75 USD 1 napon belül
(0 vélemény)
0.0