import excel

  1. K

    Import Excel sheet to Access

    Hi, I am attempting to create a convertor tool in Access which will take values in a given spreadsheet, perform the conversion calculation and then export back to excel. So far I have managed to perform the calculation effectively as well as export in a limited way. Basically I am just looking...
  2. 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...
  3. 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...
  4. 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...
  5. 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"...
  6. 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...
  7. 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...
  8. 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."

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top