Import and Export XLS into Database

Topics: Developer Forum, User Forum
Sep 3, 2014 at 3:37 PM
I need to be able to upload a xls file into the database (replacing the existing data with the data contained in the file, the column headings match up to the columns in the database), and then export the database as a xls file.

When importing I would need it to ignore the first row (a header), and when exporting I would need it to insert a header row.

Could someone point me in the right direction or link me any examples in the documentation, I couldn't find any.

Thanks for any help you can provide