[DUG] Importing data from Excel

[David Brennan]

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-bounces at delphi.org.nz [mailto:delphi-bounces at 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 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

_______________________________________________
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