Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Range Mess | Charts and Charting in Excel | |||
data import and export in to access | Excel Discussion (Misc queries) | |||
Data range properties | Excel Discussion (Misc queries) | |||
Export Excel Data to Access With a Macro!!! | Excel Discussion (Misc queries) | |||
Refreshing Access data in Excel | Excel Discussion (Misc queries) |