Page 1 of 1
Posted: Tue Feb 04, 2003 12:18 pm
by BackupUser
Restored from previous forum. Originally posted by JoRo.
I am trying to read in an Excel Database, the file has only one sheet and beginss in the left corner, only text for testing.
But it doesent work. So,
what is wrong witth this code?
InitDatabase()
Result = OpenDatabaseRequester(1)
For p=1 To 12
Text2$ = DatabaseColumnName(p)
MessageRequester("",Text2$ ,#PB_MessageRequester_Ok )
Next
FirstDatabaseRow()
For p=1 To 12
Text$ = GetDatabaseString(p)
MessageRequester("",Text$ ,#PB_MessageRequester_Ok )
Next
End
Ps Its my first attemp in DB
Johannes
Posted: Tue Feb 04, 2003 12:29 pm
by BackupUser
Restored from previous forum. Originally posted by Manolo.
Originally posted by JoRo
I am trying to read in an Excel Database, the file has only one sheet and beginss in the left corner, only text for testing.
But it doesent work. So,
what is wrong witth this code?
InitDatabase()
Result = OpenDatabaseRequester(1)
For p=1 To 12
Text2$ = DatabaseColumnName(p)
MessageRequester("",Text2$ ,#PB_MessageRequester_Ok )
Next
FirstDatabaseRow()
For p=1 To 12
Text$ = GetDatabaseString(p)
MessageRequester("",Text$ ,#PB_MessageRequester_Ok )
Next
End
Ps Its my first attemp in DB
Johannes
Hi JoRo,
The commands from PureBasic databases work only via ODBC interface, not directly to the database.
You need one ODBC draiver for Excel (Default from Micro$of in ODBC)
Regards,
Manolo
Posted: Tue Feb 04, 2003 2:10 pm
by BackupUser
Restored from previous forum. Originally posted by JoRo.
Hi Manolo,
the path is to an dbf.dsn file, not direkt to the .xls.
Well, this try will only make sence, if the normal user is able to select the right database, so the requester. If he isnt, it is nearly impossible, to build an importmodule for acces, excel or outlook.
Johannes
Posted: Tue Feb 04, 2003 4:21 pm
by BackupUser
Restored from previous forum. Originally posted by Rings.
JoRo, please take some seconds and look into 'TESTDB', an snippet from me with database , placed on the Snippets-Resourcesite from Paul.
Its a long way to the top if you wanna .....CodeGuru
Posted: Wed Feb 05, 2003 7:36 am
by BackupUser
Restored from previous forum. Originally posted by JoRo.
Thanks for the hint,
well, I have tested the code. The MyPointer Procedure doesent compile, because of the "dword", but it also runs without this procedure (why the hell, I dont know)
I have tried to open with this code an own mdb or xls, but get every time "bad query".
I have developed my Organizer as file managment system, and I think it was a wise decision. It seems, that DBs doesnt solve problems, but generate them.
I will search for another solution, to give my users the possibility, to import there selfmade adressoverviews excelfiles in my organizer.
Johannes