importing

[Joey]

I want to import information from another program called qfiniti and also
from a program named Totalview. totalview is the backoffice of IEX which is
an attentence monitoring system.

 

[John W. Vinson]

I want to import information from another program called qfiniti and also
from a program named Totalview. totalview is the backoffice of IEX which is
an attentence monitoring system.

You'll probably need to get some tech support information from qfiniti and
from Totalview. Do they expose their information in some way that Access can
import - comma separated text files, Excel spreadsheets, XML? Or do they
provide an ODBC connection?

This isn't really an Access question, in other words!

 

[hiroshi]

I want to import information from another program called qfiniti and also
from a program named Totalview. totalview is the backoffice of IEX which
is
an attentence monitoring system.

 

[Joey]

QFINITI WILL LET ME EXPORT FILES IN XML BUT I HAVE NO CLUE HOW TO WORK WITH
AN XML DOC...iT'S JUST SOMETHING I'VE NEVER HAD TO DO I'M VERY KNOWLEDGEABLE
AND CAN FIGURE OUT JUST ABOUT ANY PROGRAM OR CODE BUT I DONT EVEN KNOW WHERE
TO START AND TOTALVIEW EXPORTS INTO EXCEL DOCS.

 

[John W. Vinson]

QFINITI WILL LET ME EXPORT FILES IN XML BUT I HAVE NO CLUE HOW TO WORK WITH
AN XML DOC...iT'S JUST SOMETHING I'VE NEVER HAD TO DO I'M VERY KNOWLEDGEABLE
AND CAN FIGURE OUT JUST ABOUT ANY PROGRAM OR CODE BUT I DONT EVEN KNOW WHERE
TO START AND TOTALVIEW EXPORTS INTO EXCEL DOCS.

Please lay off the Caps Lock. It's hard to read and considered impolite -
looks like you're SHOUTING AT US.

You can use File... Get External Data... Link or File... Get External Data...
Import to get data from Excel; you can also use it to read XML data, depending
on your version of Access (the later the version the easier).

 

[Joey]

Sorry I have to write in caps for work and i'm just use to it...thanks for
info tho