Excel - How do I set up an Excel file to be imported into Access
Asked By debsews2002
09-Feb-10 04:56 PM
I have an excel spreadsheet of names. I want to pick certain names to make
labels through access. I have tryed to go to access and import the excel
spreadsheet but when I try to Browse to the Excel spreadsheet the Browse
function will not work. What am I doing wrong? Thanks in advance I am using
Office 12 Suite 2007
Office
(1)
Excel
(1)
Behaves
(1)
Daat
(1)
JR Hester replied to debsews2002
You do not have to "import" the spreadsheet, just go to external daat and link
to the spreadsheet. It behaves as a table within Access for data extraction
and use in mail merge operations.
HTH
scrolling pages in print preview Excel Excel 2003 scrolled through pages by rolling mouse button in print preview view. In Excel 2007 you have to click on the next page button, which is only visible if you have the ribbon maximized. Anyone have a work-around to restore functionality in 2007? Excel Miscellaneous Discussions Excel 2007 (1) Excel 2003 (1) Office (1) Intellimouse (1) B444bf18 (1) Behaves (1) Excel 2007 behaves the same way as 2003 for me. Scrolling with the mouse
Averaging only the non-zero entries in a row? Excel Office Excel 2007 Is there a way to find the average of column of figures EXCLUDING any non-zero entries? Many thanks. Ken Isaacson SILENT COUNSEL, a legal thriller www.KenIsaacson.com Excel New Users Discussions Excel 2007 (1) Excel 2003 (1) Office (1) AVERAGE (1) DB (1) Isaacson (1) AVERAGEIF (1) Thriller (1) Since you mention Excel 2007, one of the new functions is AVERAGEIF. So: = AVERAGEIF(A1:A100, "<> 0") - -ron Excellent
Problem opening an.xls or xlsx file Excel Excel 2007 (Office 2007), WinXPSP2, 1.56GigRam, 60Gbt free, 2.1GHz processor. When I select an .xls or .xlsx file from the file manager (Windows Explorer), Excel immediately starts, instead of a blank spread sheet the screen below the menu bars is 90 seconds later the file opens. If I open a previously unopened file directly from Excel using its file management function, it opens immediately. Same is true if I open a previously opened file from the Excel file manager, it opens immediately. Strangely, when I use the Excel file manager to select a file, when the file is highlighted, it does not appear the "file name" window. Whether files of type is set to all files *.* or All Excel files types. What is wrong with this picture? Excel New Users Discussions Microsoft Excel (1
Explorer won't open Excel 2010 Excel Ever since I installed Excel 2010 I cannot open an Excel file from Explorer. When I click on a file Excel opens but the file is not there. Files open fine when opened from within Excel. Is there a setting that will fix this? Thanks Excel Discussions Office 2003 (1) Office 2010 (1) Excel 2010 (1) Excel 2007 (1) Bit (1) XP (1
XP 2002 Office Suite vs. XP 2003 Office Suite Excel I have a 14mb excel template with approximately 100 worksheets. The template was developed in Windows XP using Excel 2002. All excel files created from the template are stored as Excel 2002. Files developed from the template in Excel 2002 work fine. When a copy of the template is made and the copy of