Strange ....Excel to Access Question

[ribhead]

I have created some Excel 2000 Workbooks that contain data for production. All of these workbooks contain identical headers and everything. I tried sharing the workbooks so operators could enter info at the same time but we were losing info because of how Excel saves changes with shared workbooks. My question is.... Can I gather my information in a Read Only Excel Workbook send the info to Access close the workbook without saving and not lose the information in Access? Sounds like a stupid question (probably is) but I'm not at all familiar with Access so I'm looking for any information available. I CANNOT use Access as my main means of gathering the data..... The king's orders.

Any help would be 1 N D rrrrrr FULL


Thanks
Mr. Rib

I know a little about nothing and even less about everything.

 

[JVFriederick]

Well......
If you send an email to JVFriederick@Yahoo.com I will be glad to send an XL file and MDB file that work together.

The XL file is used to store data into the MDB file. Once there, reports and queries can be ran against the database of course.

If you are somewhat handy with VB code, you can modify to fit your needs. If not, I may be able to help.

 

[ribhead]

Thanks for the early response JV. I'm not sure you want me to do that since I may be wasting your time. Here is what my plan is so tell me if I'm taking too many steps.

1. Operator opens the Read-Only Master.

2. When Operator goes to save the Read-Only Master I then check for an available open workbook (I have 10 in the folder). then I export all the data to one of the 10 workbooks and save it.

3. Now, I'd like to send the newly queried info to the Access Query or database for storage. Also I have approximately ten workbooks that I need to do this to.

I will send you what I have and let me know what you think I should do.

Thanks a bunch Rib

I know a little about nothing and even less about everything.

 

[TJones76]

What was the solution to thise one? I have a similar situation that I need to do with 14 separate worksheets that are on a network drive.. i need to link these into access ..into 1 table for analysis.
Also, one of the problems i've encountered is data type mismatch issues with linked worksheets. How can I resolve?

thanks for your help!
Tiffany

-Tjones76

 

[luceze]

You could always link each worksheet as a separate table in Access then create a union query to join the tables.

HTH,
Eric