Hello All!

Fairly new to the world of Access, but I'm having fun.

I'm trying to import/open a text file from a proprietary front end
connected to a sql DB. It outputs what appears to be a space delimited
format. Or, I could connect to the DB and pull the data I need through
ODBC.

Any one have any tips to, for all intents and purposes, setup a word
template in access (no calculated fields, just read some data from
another DB and display it) and output to paper, pdf, etc.

Due to the complexity of setting up an ODBC connection (politics,
knowledge), I would prefer to get this DB going with opening the tab
file, but all of my experiments thus far have not worked.

The text file looks a little like:

We are pleased to submit the following estimate.
Please call if you have questions or need to make changes.

Estimate Number 5043 Salesperson James Graham
Estimate Date 02/13/2004 Estimated By Gonzalo

Thanks in advance,

BR

Hi
I'm still not sure what you want to do with the file.
You can tell the import that the delimiter is CR.
Then each line will go into a single text field.
If there are tabls in the right places, you can use tab as the
delimiter.
In that case the first 2 lines would be in 2 records, first field only
and the next would be in multiple fields depending on where the tabs
are.
If I had to deal with this I would just write code, but I realize that
you don't know how to do that yet.
ODBC is really the way to go as you would have fields and non of the
boilerplate junk.
ODBC drivers are actually trivial to set up. They look much more
complex then they really are. You may need to get an ID and Password.
Specifically what is the DB this is coming from? SQLServer? Oracle?

Good Luck
Ira Solomon


On 15 Feb 2004 20:44:08 -0800, benross7 (AT) yahoo (DOT) com (rossta) wrote: