transferspreadsheet

  1. Z

    Pull .csV files into Database table Using VBA

    I have tried several different code changes to convert this macro code to pull in .csv files instead of .xls files. Can someone help me figure out how to make this work? All of the other forums that I have found do not provide a solution that works. Thanks in advance. Public Sub PullData() Dim...
  2. M

    Excel VBA - Import range of data from Excel to Access table

    I am creating a macro in Excel 2010 that selects a range of data (which changes each month) and copies that range into a table in Access 2010. I am getting the error message "Run-time Error 2498: An expression you entered is the wrong data type for one of the arguments." The macro stops at...
  3. U

    Exporting Multiple Queries on different worksheets of a workbook

    Hello I am new with Access and VBA, My purpose is to export Queries in one workbook but different worksheets. I am working with Access 2007. When I add an Ouput file for the Queries to go in a specific workbook I get a compiling error stating: "Compile error.in query expression...
  4. G

    Cells outside the range of cells defined in spreadsheet

    Hi all. Can someone please help with this problem? I have a code module in Access that runs a query that produces a one-record table and that record contains a total. Then the code runs this on an Excel Spreadsheet: DoCmd.TransferSpreadsheet acExport, 8, "TOTAL_TABLE", "SpreadsheetName", False...
  5. Darren Bartrup

    Importing union range into Access.

    Morning all, I've been working on importing an Excel worksheet into Access allowing for the fact that the number of columns in my worksheet will change (so I can't have a single table with x number of fields). The worksheet is basically a work count for the team; I've got 10 columns that...
  6. A

    Exporting to Excel using TransferSpreadsheet

    I have the code below that exports data to an excel file and creates a tab for each query ran. If It runs more than 5 TransferSpreadsheet commands then It error outs with Error 3011. It is not consistent. Sometimes it runs but other times it fails. It is in a Loop and it runs the line below...
  7. A

    DoCmd.TransferSpreadsheet with potential multiple worksheets in multiple workbooks

    Hi all, I've got this code (see below) to import a designated worksheet from multiple Excel workbooks into Access (using Office 2003 for both), which works a treat. My issue however is that I can't figure out how to make it now check if a certain worksheet exists (in this case "Detail_1") in a...
  8. B

    Need Help with transferspreadshet VBA

    I hope someone can help me with what will probably end up being an easy problem that I'm overlooking. I have a public module set-up to import multiple .xlxs files from a folder location. It has been working fine. However, I changed the name of the table (by right clicking and rename) and...
  9. dakota727

    DoCmd.TransferSpreadsheet not transfering text values

    I am using the following to transfer Excel data into a database. DoCmd.TransferSpreadsheet acImport, 8, "tblRawData", strInputFileName, True, "" One of the fields [Result] fails to transfer a value when it has a value with a less than symbol (<0.04). The table I am importing into tblRawData...
  10. 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...
  11. B

    Transfer multiple info from 1 worksheet to another if certain critera is met

    I am trying to create a spread sheet for my company to track specific company information. They have a ton of forms we have to fill out manually that has a lot of redundent information... and I have been able to create a group of linked work sheets that can fill in all most all the worksheets...
  12. A

    How to save and close an excel using Access VB code

    I have two procedures in two different access forms. First procedure executes fine. It ends up with creating a Table1 by importing the data successfully from the Excel file. But after that later when I call procedure 2, it throws the below error when it is trying to import the data in to Table2...
  13. A

    How to save and close an excel using Access VB code

    I have two procedures in two different access forms. First procedure executes fine. It ends up with creating a Table1 by importing the data successfully from the Excel file. But after that later when I call procedure 2, it throws the below error when it is trying to import the data in to Table2...
  14. J

    "TransferSpreadsheet"

    I have excel file with multiple tabs - 4 tabs total. I'm attempting to upload the various excel tabs into access with a macro ""TransferSpreadsheet". I have 4 "TransferSpreadsheet" actions for the 4 tabs. I've been able to transfer the first spreadsheet in access with the...

Some videos you may like

This Week's Hot Topics

Top