If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel forms
My Company uses excel sheets to track the daily production. These sheets are
used at other facilities and emailed to me. I am wondering if there is a way I can take these daily production reports and just import them into access. I have already imported one and the formulas didnt work. this is not a standard straight across sheet it has many different coloums and formulas for each of our crews working. |
#2
|
|||
|
|||
Excel forms
Make a copy of the Excel. Click in the upper left corner so as to highlight
the entire sheet, copy, and paste special - values. Then you can import them. "faith5134" wrote: My Company uses excel sheets to track the daily production. These sheets are used at other facilities and emailed to me. I am wondering if there is a way I can take these daily production reports and just import them into access. I have already imported one and the formulas didnt work. this is not a standard straight across sheet it has many different coloums and formulas for each of our crews working. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can we import an Excel sheet to use as base for report? | StargateFan | New Users | 9 | November 4th, 2005 07:32 PM |
Excel 2000 - Column labels for forms | Abay | New Users | 2 | August 23rd, 2005 02:23 AM |
Excel Forms | pauluk | General Discussion | 1 | June 25th, 2004 04:02 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |