I am trying to use Datalinks to import some excel tables. Everything is working fine except for two issues:
1- I am having trouble controlling the text height within Excel. I know this can be changed in the table properties once the datalink has been inserted, but I would rather control the text height in Excel. For example 10pt font ends up being .1388, but when I import the Datalink, I get .0972
2- Text Style. Is there a way to use a shape font? Or any other font than the font used in Excel while maintaining the datalink?
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register