* Get vendor data entered online and create Vendors in QuickBooks. * Get customer data entered online and create Customers in QuickBooks. * Get orders entered from an online e-commerce system and load them into QuickBooks as Sales Orders and Invoices. * Load a set of comma-delimited text files into a MS SQL Server database. * Extract a series of Excel files and convert them into Fixed-length text files to feed another system. * Extract Invoices from QuickBooks and update opportunities in Salesforce * Extract Accounts from Salesforce and create Customers in QuickBooks. * Extract Opportunities from Salesforce and create Customer Jobs and Sales orders in QuickBooks. Join your peers on the Internet's largest technical computer professional community. It reduces manual work by being able to run automatically. It reduces effort in conversion and migration. It reduces errors in data transformation. Anyone with MS Access level experience can configure it. Tasks can include extraction of data from various databases and applications, conversion of data from one type to another, migration of data from one system to another, etc. QXchange can be used for many data related tasks. Users can view the errors, identify the source and fix it. Error logs and process logs are automatically created by QXchange. Mathematical and other functions can be applied to the data before updating.
Individual field level data can be converted easily to other formats. Mapping of data can be done by dragging and dropping the tables or columns from the source database to the destination database. These stored profiles can be invoked and executed by the user or can be scheduled to run in batch mode using Windows scheduler. The instructions are stored and managed as profiles. It allows simple and clear setup of extraction, transformation and loading instructions to exchange data between different formats. It can quickly and easily transfer data between many standard data formats and applications, including QuickBooks, SalesForce, MS Access, Excel, Comma delimited flat file, MS Dynamics Great Plains GP, MS Dynamics AX, MAS500, Peachtree/Sage 50, ODBC, MS SQL Server, MySQL and others. Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.QXchange is a flexible, easy to use, data integration software. Optionally, the ODBCConnection object may also include authentication credential information, or a command that is to be passed to the server and executed (for example, a SELECT statement to be executed by SQL Server). When Excel opens the workbook, it creates an in-memory copy of the ODBC connection known as the ODBCConnection object.Īn ODBCConnection object contains information related to the connection, such as the name of the server to connect to and the name of the objects to be opened on that server. An ODBC connection can be stored in an Excel workbook.
0 kommentar(er)
