Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the 1 Click DB Import Wizard ?

April 26, 2017Click DB import Wizard

0

10 Posted

What is the 1 Click DB Import Wizard ?

1 Answer

0

10 Posted

The Import Wizard supports imports from Excel, Access, mySQL, Oracle or SQL Server to SQL Server, Oracle or MS Access with custom field mapping, expressions, and code events that can be saved for later reuse. You can try the demo online but since uploads to this web server is not supported you can only demonstrate SQL Server to SQL Server transfers. Once you do the mapping, running it again is just a few clicks to upload and execute your saved specification. Because it uses ADO, this tech works great with lots of different import datasources (including FoxPro and Oracle). However, Microsoft Excel data must be in tabular format or ADO will have a hard time interpreting it. All file based data like Microsoft Excel must first be uploaded to the web server with appropriate permissions set to view with 1 Click DB. This can be done with ASP, COM or simple ftp code not included with 1 Click DB. To use 1 Click DB (or any ADO program) for different text file formats you need to define a schema.