Importing & Exporting Data

[stm8ter]

I am not sure where to post this question if I am in the wrong area please let me know and I will move on. Thanks

I am having some problems trying to export data; there must be a step I am missing.

I have a data entry form for purchase orders. Several projects may require the identical materials so I would like to export the Purchase Order data to an Excel spread sheet. Then I would like to be able to import it back to different Purchase Order.

I access the data in data sheet form.
I OPEN the information I want to export. (sorry just thought of this) The informatrion I want to Export is in a sub Table.
I export to an excel file.
Result is I get ALL of the Data Sheet View
I do not get the opened information that I want
I have tried to highlight the open information
This was also unsuccessful

Seems like a pretty easy operation, however I seem to be missing something.

 

[Sameer]

Instead of exporting the table, create a query with required fields and export the query to excel.I think, this will solve your problem.

 

[stm8ter]

Exporting & Importing

Thanks for your suggestion
This may work, however I need to have users be able to export and import. The current office practice is to use an excell spreadsheet to compare items and prices. Once this step has been completed the Item Description and Unit Price is input into a "Access" Purchase Order form. I would like to import the information from that spreadsheet into the form and eliminate the duplicate entry process. It is my understanding that it is a fuction avaliable thru access, however I am not quite getting the results I am looking for, I am sure it is user error. I realize this is not as much a data base programing question as a user training question. There may be a different site to post this.
Thanks for your help.