Loosing Data and Renaming

[Noway]

Hello,

I have a Access 2010 database. I am trying to upload / import an Excel sheet using a form from the Access. When I upload the excel, it says wait processing, when it says done. I check no informtion was uploaded, and the excel sheet loosing all data and the colums are being renamed.

Does anyone know why?

Is it because the colum names do not match on both ends?

 

[David R]

Does anyone know why?

Not without a lot more information. What does your form do? Does it run a Macro or some VBA code? Post the code/macro and we can help debug it, but all you've said right now is "it doesn't work!"

 

[Noway]

It fills in a data sheet with information already in it, fills the spaces up with the dataneeded, I have Macros, and Modules...I cannot post them due to the job that I do but what could be the problem if it was working fine and then something changes...I believe the system changed it colums names and do not match with my db. I was just seeing if anyone else had this type of problem if it was common. Sorry I cannot post any of the cod.

 

[JHB]

Without code, then I'm afraid you'll be left alone.

I believe the system changed it colums names and do not match with my db.

Then check it.

 

[David R]

You can spoof the field names or whatever for confidentiality, but without seeing what you are TRYING to do, we can't really help you.

You suspect the field names have changed... but have you checked??