Re: [DUG] Importing data from Excel

lto:delphi-boun...@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 wi

Re: [DUG] Importing data from Excel

;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

Re: [DUG] Importing data from Excel

om: 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

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 Ex

[DUG] Importing data from Excel

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 impo

Re: [DUG] Importing Data

12:15 PM Subject: Re: [DUG] Importing Data Also, if your loop is taking a long time then you might want to add some code to update the form, especially if you are using a progress bar or something. You could use UpdateWindow(Handle); //just updates the screen or Application.ProcessMessages; //will up

Re: [DUG] Importing Data

Also, if your loop is taking a long time then you might want to add some code to update the form, especially if you are using a progress bar or something. You could use UpdateWindow(Handle); //just updates the screen or Application.ProcessMessages; //will update the screen and handle any button

Re: [DUG] Importing Data

I don't recognise >i := TIntegerField ; I'm guessing that you don't need it. What does the line Edit1.Text(Integer); mean? I wonder if you want: while not PSQLQuery1.EOF do begin i := PSQLQuery1.FieldByName('Count').AsInteger ; Edit1.Text := IntToStr(i);

[DUG] Importing Data

Hi In my pursuit of learning at least some Delphi, I have this challenge for which I would appreciate some help. I am having a little difficulty with this part of an expression- while not PSQLQuery1.EOF do begin i := TIntegerField ; i.value:= PSQLQuery1.FieldByName(

[DUG] Importing Data

I have a PostgreSQL database holding two tables Drawings and Devices. Each of the drawings holds devices numbering between 0 - 100. I also have a Delphi interface with which a user can select a device, the application then performs a procedure then updates the Devices table with an interface ge

RE: [DUG]: Importing data

Scott Cree Sent: Wednesday, 20 December 2000 9:27 am To: Multiple recipients of list delphi Subject: [DUG]: Importing data How can I load a text file into an interbase table? Is there a Load command like in Informix, that can load a csv file? Cheers, Scott

RE: [DUG]: Importing data

phi Subject: RE: [DUG]: Importing data No luck with interbase on that front. It can treat tables as being external, and this deals only with fixed length records. That is actually a good idea to put forward for the IBConsole now that I think of it. Myles. > -Original Message-

RE: [DUG]: Importing data

Multiple recipients of list delphi > Subject: [DUG]: Importing data > > How can I load a text file into an interbase table? > Is there a Load command like in Informix, that can load a csv file? > > Cheers, > Scott. > --

RE: [DUG]: Importing data

TECTED]] > Sent: Wednesday, December 20, 2000 9:27 AM > To: Multiple recipients of list delphi > Subject: [DUG]: Importing data > > > How can I load a text file into an interbase table? > Is there a Load command like in Informix, that can load a csv

[DUG]: Importing data

How can I load a text file into an interbase table? Is there a Load command like in Informix, that can load a csv file? Cheers, Scott. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]