How do I Export range of row/column data to Access
DESCRIPTION OF CURRENT SITUATION:
I have an Excel file that my field techs enter data and print customer reports from. The file contains multiple sheets. The field techs enter data into sheet1. They print a report in Sheet2 which uses the data in Sheet1. Before the next job, I have a routine that the techs invoke that clears the input sheet (Sheet1) and saves the data into a row/column format in Sheet3 (some of the data in these fields are in paragragh format). QUESTION: I want to export the range of data in the row/column format in Sheet3 to a file that can be easily imported into Access. Please steer me in the right direction on the best way to do this. Thanks |
All times are GMT +1. The time now is 07:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com