Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
WDR
 
Posts: n/a
Default Exporting data in Excel permanently to Access

How do I export a range of data which is in a row/column format (i.e.,
row=record, column=field) in Sheet3 to a file that can then be easily
imported to an Access table?
Please point me in the right direction on the best way to do this. Thanks

FURTHER DESCRIPTION OF MY CURRENT SITUATION:
I have an Excel file that my field techs enter data and print customer
reports from. The file contains multiple sheets. Sheet1 is the data entry
form. Sheet2 is the report then print which uses the data in Sheet1. Then,
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).

  #2   Report Post  
Posted to microsoft.public.excel.links
WDR
 
Posts: n/a
Default Exporting data in Excel permanently to Access

P.S. It would help if you knew I was using Excel 2000

"WDR" wrote:

How do I export a range of data which is in a row/column format (i.e.,
row=record, column=field) in Sheet3 to a file that can then be easily
imported to an Access table?
Please point me in the right direction on the best way to do this. Thanks

FURTHER DESCRIPTION OF MY CURRENT SITUATION:
I have an Excel file that my field techs enter data and print customer
reports from. The file contains multiple sheets. Sheet1 is the data entry
form. Sheet2 is the report then print which uses the data in Sheet1. Then,
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).

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 Access Pages - Excel 2003 Balaji Excel Discussion (Misc queries) 0 October 11th 05 06:42 PM
New Excel data does not appear in linked Access table JohnL Excel Discussion (Misc queries) 0 October 7th 05 04:31 PM
Send Excel data to Access through button julesferreira Excel Discussion (Misc queries) 1 June 17th 05 07:30 PM
MS Excel data reading in MS Access Paul Excel Discussion (Misc queries) 1 January 27th 05 12:58 PM
Fetching External Data from Excel Sri Excel Discussion (Misc queries) 2 January 3rd 05 12:46 PM


All times are GMT +1. The time now is 04:00 PM.

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"