StevieRayB
New Member
- Joined
- Mar 28, 2009
- Messages
- 3
Hi all;
I have an Excel workbook that has 2 worksheets named "decision" and "quality". I need to load these 2 worksheets to Access into 2 seperate tables named (you guessed it) "decision" and "quality".
I have a form that builds the path and filename portion of the macro to execute the "transferspreadsheet" command.
I need to know exactly how the "filename" that includes the path is supposed to look to load the "decision" worksheet into the "decision" access table and the "quality" worksheet into the "quality" access table .
The path and filename is:
g:\excelfiles\accesstransfer\daily-transfer.xls
Thank you.
<!-- / message -->
I have an Excel workbook that has 2 worksheets named "decision" and "quality". I need to load these 2 worksheets to Access into 2 seperate tables named (you guessed it) "decision" and "quality".
I have a form that builds the path and filename portion of the macro to execute the "transferspreadsheet" command.
I need to know exactly how the "filename" that includes the path is supposed to look to load the "decision" worksheet into the "decision" access table and the "quality" worksheet into the "quality" access table .
The path and filename is:
g:\excelfiles\accesstransfer\daily-transfer.xls
Thank you.
<!-- / message -->