[DUG] Importing data from Excel

[David Brennan]

Hi Todd,

Client local drives can be accessed from a Terminal Services/Citrix
connection so long as the user has allowed access to them. They appear as
mapped drives. If the user hasn't allowed access then that is their problem!

Sounds like it would work and isn't something I considered - thanks for
suggesting it. Nonetheless I'm tempted to try a standalone third party
solution first because then it will work on all customer computers with just
our EXE and nothing else installed.

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 11:06 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] Importing data from Excel

Hi David

Provided you have installed the MS Access database engine, you should be
able to connect to an Excel file without MS Office being installed on
your server.
Check out this link
http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-
A44B-84B371EDE16D&displaylang=en

How are you planning on passing the local Excel file to your server?

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
> 
> _______________________________________________
> 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