Import .xls documents

[Eppo]

Hi,


I'm working on a customer system with nuBuilder.
The only problem i have is that al my cutomerinformation is in a excel sheet.
Because I have MS Office 2010 i cant make .mdb files.
What options do I have to import it in nuBuilder?


Thanks for the hard work.

[admin]

Hi Eppo,

nuBuilder has no way to import Excel tables but Phpmyadmin does. You could try that.

BTW Eppo, how did you hear about nuBuilder?

Steven

[Eppo]

Hi Steven,


It finally succeeded. I made some mistakes woth the ID table.

I was searching for mysql database programs and some of the programs I found was yours.
This is the one that is easy to use and easy to configurate.

I've got one more "Mayor" problem and that's a sorting one. I want that al browser forms automatically sort on date, so that the last entry is on top of the first page.

Can you help me with that?


Thanks for the hard work.

[admin]

Eppo,

Use a query on the Form, that is already sorted..

Code: Select all

SELECT * FROM mytable
ORDER BY mydate DESC

Capture.PNG

Steven

[Eppo]

Hi Steven,

Thanks! It works Great.

[admin]

.