Data Import Wizard...

[BilboBaggins]

We're wanting to write a data import wizard similar to the MS Access Import wizard. We need something to enable fairly non technical end users to import into our application from a variety of datasources, Access, CSV, Excel etc...

Does anyone know of a 3rd party component for something like this? We need something with a simple interface.

I'd appreciate any feedback.
Jeff

 

[jmcilhinney]

You don't really need a component. Just write an interface to ADO.NET code. You can mimic the functionality in Access you speak of if you wish. You can use OLEDB or ODBC for a wide variety of data sources so your code can be almost identical for all data sources with just the connection string changing and small changes to the SQL code in some cases. The VB code would be unchanged regardless of the data source.