access import

  1. V

    Linking a table from online Excel file

    Due to a transition, I now have to use an online portal to connect my current excel files (located in local drives now) to my access database. Does anyone know how to import an HTML website which is an Excel file to access? Similar to Office 365 Excel FILES. The actual source I'm using is a...
  2. E

    Import in ACCESS: DoCmd.TransferSpreadsheet acImport - ERROR "Record is too large"

    Hello, I need some help with the following issue. The task is about importing more than 100 sheets from one excel file. I tried with SavedImportExports, but it is not flexible for management. Then I made some progress with Macro>ImportExportSpreadsheet - in design view and the modified in VBA to...
  3. H

    VBA that formats sheetname based on the sheetname itself

    I get an excel workbook everyweek that has 7 sheets on it. The person that sends the file puts the name of the sheet and the date range (i.e. OutPatient 01-01-2011 - 01-08-2011) when I import this into access it creates a table based on the sheet name. I want to append the data so I need to...
  4. J

    Losing Data when Importing from Excel to Access

    I am working in an Access Database and have pasted data from Excel. I did not receive any paste errors, but found that there was a bunch of data missing from the Access table. After reviewing, it appears that the excluded records included quotes in the description field. I figured out how to...

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