External Data

[Bruce]

Office 97

I linked data from a Query in Access to an Excel spreadsheet & from that
data created a Chart & it worked fine. However when I put the database and
sreadsheet on my home PC as expected it lost the link.When I tried to
recreate the link on a ne spreadsheet all I get is a message saying
something about the data in column one is trucated. Nor do I have in the
dropdown an option for a straight link to Microsoft Office Access.mdb ,they
have other words in like "do"

Thanks Bruce

 

[Vincent Johns]

Bruce,

It's possible that you have mismatched versions of Office (i.e., not
the same versions with your original spreadsheet & database as the ones
you use at home).

Assuming you can't get matching versions, it's possible that you
can't link directly. If Column 1 is your only problem, you might just
omit that from the Query that you're importing. (You could define a
Query that omits Column 1, and import that.) Or, maybe Column 1 is a
long Text field that you could truncate to a shorter size using
something like Left$([MyLongTextField],17).

Something else you might try, in your home version, is to write the
contents of your Access Query to a text file, and then import that file
into Excel. (You could then delete the text file.)

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.