Search results

I get these spread sheets sent to me. I have no control over the layout or headings. In the sheet I appended the 3 columns are titled "27/10 Div", "31/10 Close" and "31/10 P/E" in the next week's sheet they are "03/11 Div", "07/11 Close" and "07/11 P/E". So obviously Access won't recognise...

Yes, I was thinking along the same lines as well - import all 36 then analyse. The only slight downside to this is that I get a new spreadsheet each week, but I suppose it does not matter. I've uploaded a sample workbook here BTW moderators - forum does not recognise or accept xlsx (Excel...

OK, it looks like the command I will have to use, but I'm not very happy with Macro / VBA programming. So I looked it up in another site and they say :- Create a new macro, and in the first action box select “TransferSpreadsheet”. Tried that (actually I'd got that far before I started looking)...

I have a number of Excel spreadsheets (1 a week for the past 9 months - so far) in which 3 columns contain the same data (name1 name2 and class) from week to week but the other 12 change. There is also a column containing the creation date, repeated for every row. There are approximately 100...

Thanks Shane, almost there. That certainly looks the way to do it, but I'm getting a type conversion error on the very last step, the actual import. I'm still working on it. Maybe it's because the table from which I'm trying to import is actually a link to the Excel spread sheet containing the...

I am familiar with RDB in general, but not with the specifics of Access data entry. I have created a simple database from an Excel spreadsheet that tracks my investments. The spreadsheet contained 3 columns, stock name, date and value.There was about a year's worth of data making some 4500...