Import/Export

[Guest]

Hello,

We have system we use to input our loan information. From that, we pull a
report which downloads as a text file. We can then import it into an excel
spreadsheet to view. From this information, we have a letter that goes out to
customers and what I am trying to do is to get the Loan Number and Customer
Address from this spreadsheet to the letter that was created from a word
document.

Am I somehow able to take the information from the spreadsheet, import it
into an access database and then have that drop the information in the word
document letter?

Currently, we have a database that does this but only for Delimited files.
This report downloads as a text file.

If you could please help or at least guide in the right direction to a web
site or anything would be very much appreciated.

Thank you in Advance!!

 

[Edward]

Doug, it is possible to import from a spreadsheet. Just goto File-Get
External Data and then select either Link or Import. If this is going to be
a dynamic thing that you want to capture each time, choose the Link. If
it's a one-time import, choose import. Choose under file type "MS Excel"
and then choose your directory and file. The screens should walk you
through the rest, but basically, you get to choose named ranges or not,
column headers or not, can change the names of the fiields or choose to skip
and then name it.

HTH. If not, post another thread, and I'll try to respond.

Edward