[DUG] Importing data from Excel

[David Brennan]

Howdi,

 

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.

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20100527/e680aa90/attachment.html