import excel spreadsheets

Hi I am totally new to Ms access and apparently I have been using the wrong application(Excel) to build my databases lol better late then never so far I have learned the basics of creating both tables and form but am having issues when importing new data. I am trying to import new data from an...

Hi Guys, First of all I am new here, Here's the problem: Why access no longer rename a blank column or has invalid character such as '.' into NoName or '#'. Is it because update? how to change the preference back to the old one? or maybe I can edit the registry to change it back? I really...

Hello Does anyone have any code where I can import excel sheets into Access from Subfolders? Many thanks

Hi guys. Please help with this situation. I'm fighting with it from this morning and i'm desperate I have an excel file as said in the title with 110000 fields and 550000 rows. I have eliminated all the potential symbols in the fields that are not compatible with access. When i try to import...

Hi All, Any help would be gratefully received on this. I have a macro which loops through various worksheets that are contained in a directory and copies them into a master workbook. The problem is that yesterday my importloop macro was working perfectly but now I am receiving Run-time...

Hi There, My Question is "Is there any decent way, where i can amend and import data on an existing powerpivot table from multimple excel worksheet?" Background: I have started a large project in PowerPivot and got stuck in one silly problem. I have a a workbook with say about 36 worksheets...

I have a few people all entering in data into excel, since they cannot be all in one sheet they each have their own copy. I would like to be able to extract all data where column P reads "Red" from each users spreadsheet and then delete the corresponding lines from their spreadsheet (end of day...

Hello all experts - I am trying to figure out the best way to do the following: Import an system generated report (Exported to a directory every hour) into a master table. The file naming structure is as follows: \\MyDir\ReportName1.DDMMYYYY.HHMMSS.xls Where MyDir = the directory structure...

I used Access to produce an .xls file (call it June2011.xls) with three sheets in it (call these NoFunds, Formatted, and FundNames). I need to create a module in Excel that creates more sheets (pivot tables, summaries, etc.) that read from the Formatted sheet as well as format the data so it's...