Page 1 of 1

Import .xls documents

Posted: Fri Jan 25, 2013 3:47 pm
by 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.

Re: Import .xls documents

Posted: Tue Jan 29, 2013 6:18 am
by 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

Re: Import .xls documents

Posted: Thu Feb 07, 2013 11:54 pm
by 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.

Re: Import .xls documents

Posted: Fri Feb 08, 2013 6:03 am
by 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

Re: Import .xls documents

Posted: Sat Feb 09, 2013 2:01 pm
by Eppo
Hi Steven,

Thanks! It works Great.

Re: Import .xls documents

Posted: Sat Feb 09, 2013 10:40 pm
by admin
.