Hi Todd, Interesting idea. We want something that can read the Excel file without Office or indeed any consumer Microsoft products being installed. In some cases it will be running on a server with the user accessing the application using Terminal Services over the internet and the Excel file will be a local file on the user's computer. So all it will be able to do is access it as a normal file using local disk mapping.
It's possible ADO would still work... but I'm a bit wary about it unless someone has already tried it!? Cheers, David. -----Original Message----- From: delphi-boun...@delphi.org.nz [mailto:delphi-boun...@delphi.org.nz] On Behalf Of Todd Martin Sent: Thursday, 27 May 2010 8:21 p.m. To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] Importing data from Excel 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@delphi.org.nz > Admin: http://delphi.org.nz/mailman/listinfo/delphi > Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe
