import data from excel

Hi Demigods, I do not have a specific issue at this time, more just want to gauge your advice... I would like to have two workbooks - one called backend, one called frontend. The backend contains rows of data. The frontend contains the backend data imported into it. Is it possible that if a...

Hi there, I'm trying to create a series of Macros in a document, that will enable us to import data from a sheet on another document, into a sheet onto the active document. Multiple people will have access to the document, at different locations, so the files the data is being imported from...

Hi everyone, Please help me with my problem regarding importing data from excel and append to my Access table error. Everytime I import my table to Access using macros, record become duplicated. This is the details of my Access tool Table : 1. FG info 2. PL list Query : 1. Append_FG info...

Hey, everyone. I would like to open some discussion on the best approach to a task I have been given for creating a solution to simplify a process. I am not Excel savvy. I can use it, do nifty things when I need to, but I am not a guru or fluent in VBA or formulas. I have been asked to help...

Hello guys :biggrin: I have a master spreadsheet with summaries, stats, and observations on about a thousand experiment results and ongoing. Each row corresponds to a unique experiment ID#. The instrument I use also generates a csv with the same name as the experiment ID#. I have tried several...

Hello and thanks for any help. I'm a noob with Access but my company has asked a question about possibly importing some information for certain records in Access. Basically, I work for an insurance company and they have a claims system which was built in Access about a decade ago by someone who...

All, I am trying to write a macro within a central model (let's call this the 'aggregator model') to open a series of spreadsheets (one at a time), then copy data and paste as hardcoded values into the central model. The main difficulty I can see, is identifying the area where the data should...

Hello, I apologize ahead of time if my description is too verbose :-) I have an Excel-based tool that has to regularly import data from 50+ user-selected, large CSV, XLS, and XLSX files into a single Excel workbook, and I am encountering a difficulty that would appear to be caused by Excel not...

Hi, I'm trying to produce a copy of a complex userform I have in Excel 2011 (for Mac). Following advice on other forums I have exported the user form, renamed the associated .frx and .frm files (which were the only exporting options) and am now trying to import back into the original workbook...

Hi all, in need of some help to import new data into new column. Currently, Ive only managed to import the data but with every new data, they are stacked below. I need them to be in a new column. Eg. data1 A2:B2, data2 D2:E2, etc... Also, is it possible to import the filename of the import data...

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

I have an excel file which has around 373 NamedRanges and their values. Some ranges are singlecell others are around multicelled value. Now I am trying to first export the Names of the NamedRanges all of them which are present in the workbook and their values in csv format. Then I am using...

Greetings!! I am new to MS Access and have been trying to use VBA to import a specific worksheet called "Access" in an Excel file (from about 400 users) into a single table. I want the code to search through one folder and import the "Access" worksheet in each Excel workbook within that...

Hi, Anyone please helping me!!! I'm very newbie I've been create MS access and want to import file by browse and select file to import. I have 1 text box name "Text01" (will show path and file name to import) I have 1 button for browse file name "btbrowse" (Browse to select file) I have 1...

Hey guys I'm a newbie on the VBA, and I need to do a project for the company I work. Every thing was going very good until I knew that I was going to need to import information from another excel file to the one I'm developing. And they said I need to take the information out of 3 columns, and...

Dear Excel and VBA experts, As of recently I have compiled a piece of VBA coding and I could use some fine tuning in it. Perhaps some help can be provided here. I’ll further explain the case and my vision on how I would like to have it work. Case: I have one source spreadsheet in which there...

Hi, I am trying to create a macro to automatically import several Excel reports into my data base in Access. The names have some similarities (I use this similarities for another macro I use that depending on the file name it gives the proper format to the file) for example dependig if the...

As the title states, I am trying to import and append multiple sheets from a single excel file into tables in my Access DB. The excel Sheet2 will always be appended to Access table1, Sheet3 will always be appended to Table2 and Sheet4 will always be appended to Table3. The sheets in excel...