acess exported to html or excel

[ljscott]

have an Access database that has contact information for all of the Institutes employees. I also have a telephone/e-mail directory that is in the form of an excel spreadsheet.

i would like to intergrate the two of these to cut down on the number of things i need to update when people join/leave the institute, which happens frequently b/c we have 8-10 new interns every quarter.

the biggest issue is that i am unhappy with the output of the access database. it changes all emails to text by placing an ' as the first character in the cell when exported to excel, or doesn't include the a href tag when exporting it as an htm document. it defeats the purpose of doing it this way when i have to go through an change all of the cells with email addresses. in excel, i tried doing a seach for the ', but it doesn't come up becuase it is only visible in the formula bar.

also, i am not happy with the way the report looks. i usually spend 15 minutes adjusting it in design view before i like it. every time i add name, i need to go back and do this again because i can't update the report with designing it over (is there a way around this?)


any suggestion on what i should on?

 

[spiralmind]

in excel you can select a column or range of cells and specify it's formatting. this might be just what you need to "untext" the emails (i'm assuming you want links).

are the names in your report set up in a column, or a row?

if they are in columns (like a phone book) you shouldn't have to redesign your report every time you add a name. just make all the columns wide enough to hold every name that will go in there.

you might also, in your imput process, be able to request that the cells not be reformatted, or pick a different format, but access doesn't support a "hyperlink" format for it's tables, and i believe that access's small list of available formats is the limiting factor behind how your data is being exported in this case.