import excel

  1. G

    scattered data import into on worksheet

    I have been researching the solution to this problem for several days with no results that match my problem. I am hoping it is possible and I have come here in hopes that someone will know. I am using Excel 2007 but have access to Excel 2010. My boss has been using an Excel sheet as a template...
  2. J

    String conversion formula?

    I am hoping for some assistance. I have Windows 7 Home Premium with Microsoft Office 10, using Excel 2010 v.# 14.0.4734.1000 32-bit. I have a tab delineated text document I have imported into excel. I am trying to then format the data to be imported into another program. The following is an...
  3. A

    Import Excel Files into single sheet from single directory

    Hi, I am positive that someone can provide help on my requirement. Currently I am having around 50+ files in one single directory and would like to import only those files which are in present in the Excel Worksheets using VBA. For example: My files are in C:\Exceldump directory Master...
  4. J

    Consolidation from templates

    ****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List"...
  5. H

    Transferspreadsheet + recd's w/dup'd keys inserted in new table:'Paste Errors'

    I am using Docmd.Transferspreadsheet to append a large Access table with a data from an Excel table. Once duplicate values are recognized in any field that should hold unique values I would like to initiate an event that opens a message box that says something like,"Records that Microsoft...
  6. S

    ways to import excel to access

    My business users dont know access at all so I need a easy way for them to import excel sheet to specific tables. Planing to develop this functionality in one of the 2 ways Design 1 - I plan to have a a separate button for each file type. When a user press this button a small window should...
  7. T

    ' ' is not a valid name

    I am trying to import an 2007 excel spreadsheet to 2007 access table and I receive this error "' ' is not a valid name."

Some videos you may like

This Week's Hot Topics