Recent content by Over analyzed

ok now this is getting really annoying to say the least. Why is it that when I have an excel file, lets say john doe that is saved on my desk top - I open access, go to create table by entering data file-import external data- find file john doe go to import it BAM error message = make sure john...

I am waiting for my IT team to upgrade....;)

also this used to be the fastest way for me to do this. End result I want to be able to do pivots in excel with all the data in access

The excel file and just standard excel file. (around 50k rows of information per excel file) When I copy and past excel data from one workbook to a new I can then import to access. I had no issues doing this last week. I am using 2002 excel and access

Thanks for the reply- I truly appreciate all your help. Due to the limitations of excel being 65k rows I am taking 3 years (05,06,07) information from various spread sheets and trying to incoporate them to one access data base. Normally how I do this is, open a blank/new data base in access...

I wanted to know if anyone else is having issues with getting external data into access from excell? For some reason this function is not working for me today. Any help would be greatly appreciated. Thanks