Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Export Excel Data for use in a Database Table
Good Morning All,
Picture a sheet that has names in cols. A:B and dates across row 9. One row is in between each name row. Actually, this in-between row is the 2nd data record for each name. The odd rows may strictly contain a comment for the people for the different days. What I'd like to do is have Excel export the names, dates, and comments (if not null) for the past 5 days, and import them into an Access table. In Access, 2 fields would be firstname and lastname, the other 5 fields would be the past 5 dates (including the current day), and the comments and the associated names would become the data in the table. The Access table should be named the current date: 08-06-07. Any help/insight would be very much appreciated. Thanks, Arnold |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export Pivot Table Data to Excel Table | Excel Discussion (Misc queries) | |||
Export data into Access Database | Excel Programming | |||
Deleting data in a table from excel export | Excel Discussion (Misc queries) | |||
export data from MS Excel sheet to external database | Excel Programming | |||
From Excel 97 Programmatically create access 97 or 2000 database and export data to. | Excel Programming |