Import excel using VBA
-
Hello It's me again with another painstaking question. I am still working on the same database (In Access 2000) and am now trying to import an excel file. My problem is that the excel file has some special formating and extra crap I don't need and do not know how to get around, so it doesn't import. If need be I can email the excel file to anyone willing to help me. This excel file is updated by a third party every week so it will be an on going import and I would like to make it as easy as possible to do. I'm sorry I'm not to detailed it's a bit hard to explain without one seeing what I am trying to do. If you would like me to email you the excel file please email me @ ri p@ gh os tm ai l .net Sorry just trying to prevent spam bots. Thank you in advance