Well, I managed to import Excel files in my Access database, thx to Justin. But the only way to make it work was to make the first row carry the column names. Now, this doesn t seem a problem, but for me it is, as I want users to fill out Excel files ( a template, actually), where the headers should be in the first COLUMN, as it's much more appealing and practical. Is there any way to "tell" Access (VB) that the matrix - the cells in Excell - are transposed?
Yes, but not as easily as you might like. What method are you using to import your excel file? For me, I would open the workbook as an object in vba, then use the values in the first column to create a new table, then create a dataset of the excel sheet sans the column header row and push it into the new table.
Also, I don't understand how putting headers in the first column is more appealing or practical... do you have a crosstab like conversion you are performing somewhere?
Yeah, that's one option, to access it through ADO. The problem is that my customer wants to handle these report-like sheets in Excel, and they have the following structure:
Last Name: _____________
a very long list, and so far I've managed to make the import work only if the sheet is formatted like:
Name| Last | Zip|......
Ian | Dury| 1234| .....
which is ugly and very user-unfriendly. The method I used is the following