ole objects,background and open dataset

[Former Member]

Hi,

I want to read ms access files on background using ole objects. Is it possible to apply open dataset operation for mdb files? As known, text files can be get into application server using open dataset. But I need to get mdb file to application server.

On the other way I can simulate my problem as, is it possible to read excel files(for example) using <b>ole object</b> in background? If I can get an aswer, maybe I can simulate it as reading mdb files.

Thanks.

[Jelena_Perfiljeva]

OPEN DATASET is meant for the flat text files, you won't be able to open an mdb file with it. Once I've tried using OLE objects to obtain the file modification date and, even though it worked great in foreground, it didn't work in the background mode.

This thread on reading MS Access files in SAP might be helpful:

[Former Member]

OLE and background are incompatible - you can only use OLE in the foreground as it runs on the presentation server.

If you need to run as a background process, you will have to use open dataset. You can read the mdb as a binary file, but I doubt you could do anything useful with it. Can you export the data you need from access into a tab separated, comma separated or fixed format file - then you can open this using open dataset and read the data.

Michael

[Former Member]

i am facing the same problem with OLE object when i run on the background so

how can i replace this OLE with open dataset (i am connecting to SQL server) .