Not sure what to do. I am able to go to excel and do an import of the database from access. So everything loads in find to excel, and can do pivottable. But what I am noticing is that where there should be text, there are numbers instead.
If I just go say to access and do an export to excel, it gives me what is in the fields. Text or numbers.
I want to be able to go through excel to import the data from access because it will always automatically update.
Is there away to make excel take what is in the field from the database.
I hope that I am asking this even right.
Please help.
Confused. :banghead:
Thank you in advance.
PS: MS Access 2010 and MS Excel 2010
Tony
If I just go say to access and do an export to excel, it gives me what is in the fields. Text or numbers.
I want to be able to go through excel to import the data from access because it will always automatically update.
Is there away to make excel take what is in the field from the database.
I hope that I am asking this even right.
Please help.
Confused. :banghead:
Thank you in advance.
PS: MS Access 2010 and MS Excel 2010
Tony