[DUG] Importing data from Excel

[Todd Martin]

Hi David

Have you considered using TADOQuery/TADOTable with the Microsoft.Jet OLE
DB provider or MS ODBC provider for Excel?
http://delphi.about.com/od/database/l/aa090903a.htm


Todd

> Has anyone used EMS Advanced Data Import VCL from SQL Manager.net to
> import excel data from a file without Excel installed?
> (http://www.sqlmanager.net/en/products/tools/advancedimport/download)
> 
>  
> 
> I found the EMS product because I was looking for something that was
> already setup to import into a prepared dataset. We ideally would like
> an interface to map columns in the spreadsheet to columns in the dataset
> and EMS also have a wizard interface for importing. However now that I
> have run their demo and seen their wizard in action... well, let’s just
> say we would probably need to write our own interface for it.
> 
>  
> 
> So that opens up the option of something like Native Excel 2 from
> NikaSoft which I believe some people on this list use? Their website
> doesn’t list compatibility with Delphi 2010, have they gone silent?
> 
>  
> 
> Any other recommendations?
> 
>  
> 
> Cheers,
> 
> David.
> 
>  
> 
>  
> 
> 
> 
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe