D5 and xls files

ADAINEN

Delphi Developer

Mon, 28 Jul 2003 03:24:29 GMT

D5 and xls files

So can enybody tell me how do I set up BDE and its properties for Excel
tables
becuse it is allways asking for some username and password and i have not
set any password on a database i created!
thanks in advance!

Adainen

M.H. Avegaar

Delphi Developer

Mon, 28 Jul 2003 17:35:45 GMT

Re:D5 and xls files

Skip the password dialog by using a TDatabase component with LoginPrompt set
to False.

"ADAINEN" <MARIO.ADA...@KR.HINET.HR> schreef in bericht
news:95s78i$4295$1@as121.tel.hr...

Quote

> So can enybody tell me how do I set up BDE and its properties for Excel
> tables
> becuse it is allways asking for some username and password and i have not
> set any password on a database i created!
> thanks in advance!

> Adainen

ADAINE

Delphi Developer

Tue, 29 Jul 2003 04:31:06 GMT

Re:D5 and xls files

Ok ,but i need a password on the database!

Quote

"M.H. Avegaart" <avegaartNOS...@mccomm.nl> wrote in message

news:95tp9p$l4v$1@porthos.nl.uu.net...

Quote

> Skip the password dialog by using a TDatabase component with LoginPrompt
set
> to False.

> "ADAINEN" <MARIO.ADA...@KR.HINET.HR> schreef in bericht
> news:95s78i$4295$1@as121.tel.hr...
> > So can enybody tell me how do I set up BDE and its properties for Excel
> > tables
> > becuse it is allways asking for some username and password and i have
not
> > set any password on a database i created!
> > thanks in advance!

> > Adainen

MrBaseball3

Delphi Developer

Tue, 29 Jul 2003 05:36:21 GMT

Re:D5 and xls files

Dump the BDE and use one of the many Excel access components on Torry's
http://www.torry.net/db_msexcel.htm

M.H. Avegaar

Delphi Developer

Tue, 29 Jul 2003 17:33:08 GMT

Re:D5 and xls files

Set the password with:

Database1.LoginPrompt := False;
Database1.Params.Values['USER NAME'] := 'myname';
Database1.Params.Values['PASSWORD'] := 'mypassword';

"ADAINEN" <MARIO.ADA...@KR.HINET.HR> schreef in bericht
news:95uvh9$8ajo$1@as121.tel.hr...

Quote

> Ok ,but i need a password on the database!

> "M.H. Avegaart" <avegaartNOS...@mccomm.nl> wrote in message
> news:95tp9p$l4v$1@porthos.nl.uu.net...
> > Skip the password dialog by using a TDatabase component with LoginPrompt
> set
> > to False.

> > "ADAINEN" <MARIO.ADA...@KR.HINET.HR> schreef in bericht
> > news:95s78i$4295$1@as121.tel.hr...
> > > So can enybody tell me how do I set up BDE and its properties for
Excel
> > > tables
> > > becuse it is allways asking for some username and password and i have
> not
> > > set any password on a database i created!
> > > thanks in advance!

> > > Adainen

Other Threads

1. Converting tab-delimited text files into XLS files

2. .csv file and .xls file

3. reading .XLS files

4. How to read a EXCEL.XLS file ?

5. How do you get Formula One .xls file in/out of BlobField

6. Accessing MS Excel 5 (*.xls) files

7. Reading and writing XLS and DB files

8. format of *.xls file

9. how can i convert qrp files to xls out of delphi

10. Save context of tabel as XLS file