What is difference between Excel WorkSheet & Excel ODBC Connection?
Excel ODBC Connection create a connection between Desktop Excel and handheld as a ODBC database. Here you can SQL queries to filter result. However, if excel contents doesn’t fit in Database Table criteria in this case only those contents which are valid will get transferred on handheld and rest contents are ignored. In such case, while synching from Handheld to Desktop, you may lose some data.
Related Questions
- I have an ODBC connection, and therefore I do not have an .odc file. How can I use my connection with a data connection library so that it will work on Excel Services?
- How do I set up an ODBC connection for an Excel Spreadsheet with using Legitronic v3.6.2 &/or Later?
- What is difference between Excel WorkSheet & Excel ODBC Connection?
