transferspreadsheet

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...