Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
WDR
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Range Mess Karen Charts and Charting in Excel 18 January 14th 06 02:34 PM
data import and export in to access nuti Excel Discussion (Misc queries) 10 January 5th 06 07:09 PM
Data range properties baz Excel Discussion (Misc queries) 1 April 1st 05 09:37 AM
Export Excel Data to Access With a Macro!!! Jac Excel Discussion (Misc queries) 3 December 28th 04 07:39 PM
Refreshing Access data in Excel Jimmy G Excel Discussion (Misc queries) 0 December 21st 04 03:53 PM


All times are GMT +1. The time now is 10:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"