Hi, Gianluigi. OK, so I got the pages to INSERT data into my MS Access db table, and then displayed it via a recordset on a "Show" page.
Now, however, I have another problem: The Excel files I am using do not have a "unique" column/key. So, in the db, I do not establish a "unique/primary" key.
When I place the EXCEL IMPORT ext on a basic page, and I select my db connection and table, into which the data will be INSERTed, the dropdown menu below that requires me to select a "unique" column. I just let it select the first column. I do NOT check the "numeric" box. I set the columns accordingly on the "Fields" tab. I set the verification to "DON'T VERIFY".
PROBLEM: My first column is just a "general" format in Excel. The column could contain a number (i.e. 1111111), or just text (i.e. A name). It seems that whatever the first data cell contains (Number or Text), that is what will be entered in the db, and the rest just skipped.
So, if the first 3 rows in the Excel file have a number in the first column, and the remaining rows have text in the first column, only the "numeric" entries are entered in the db.
The converse is true, as well. If the first data cell is text, then the remaining numeric columns are not entered.
Please help.
Thanks so much,
Shane
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Login
Unread message![Read message [popular]](http://forum.dwzone-it.com/template/subSilver/images/folder_hot.gif)
Read message [popular] ![Unread message [popular]](http://forum.dwzone-it.com/template/subSilver/images/folder_new_hot.gif)
Unread message [popular]![Read message [locked]](http://forum.dwzone-it.com/template/subSilver/images/folder_lock.gif)
Read message [locked] ![Unread message [locked]](http://forum.dwzone-it.com/template/subSilver/images/folder_lock_new.gif)
Unread message [locked]