I am wanting to import data from a table in Access, which I've done, but need
the numbers to work in Excel formulae. The numbers are importing fine, but
the calculations are not happening, unless I go in to the Excel worksheet and
retype the numbers...then the formula will work...but this is redundant any
ideas how to format the data? or to prepare the data prior to importation? I
need this data to import and display without having to re-key the data.
Thanks for the insight.