<div>
Wow capricorn, my solution was not as elegent or short. &nbsp;Kudos
</div>


<div>
Excellent!<br />
<br />
Thanks capricorn
</div>


<div>
<div class="content wysiwyg-content">
Hey all,<br />
<br />
I have an Excel workbook with 170 worksheets.. all worksheets are identical, except for the data.. I would like to import these worksheets to an Access table.. any ideas? Also the worksheet names are date serials, ie; 080701 = 2008-Jul-01, I have a 'Date' column in the Access table and would like that column populated with this date.<br />
<br />
Thanks,<br />
<br />
Bud
</div>
</div>


Hey all,

I have an Excel workbook with 170 worksheets.. all worksheets are identical, except for the data.. I would like to import these worksheets to an Access table.. any ideas? Also the worksheet names are date serials, ie; 080701 = 2008-Jul-01, I have a 'Date' column in the Access table and would like that column populated with this date.

Thanks,

Bud

Wow capricorn, my solution was not as elegent or short.  Kudos

Import Multiple Excel Worksheets to Access Database

Hey all,

I have an Excel workbook with 170 worksheets.. all worksheets are identical, except for the data.. I would like to import these worksheets to an Access table.. any ideas? Also the worksheet names are date serials, ie; 080701 = 2008-Jul-01, I have a &#39;Date&#39; column in the Access table and would like that column populated with this date.

Thanks,

Bud

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.