R
Rob
Hi there. Not sure where this belongs...
I have a commercial application that generates an access .MDB which contains
a table with a specific name. The .MDB name is random, such as..
wsT3673085907.mdb. We may get several of these .mdb with different names.
I'd like to be able to run some command line process that will tell me
whether any of these contain a specific table "ABC".
More details if you're interested. The commecial package also genearate a
CSV file from table "ABC". For some reason ( I think it may be memory
related) the CSV generation fails and someone gets called to manually rerun
the report that failed. MY thought is, if the table is generated correctly,
and it is only the CSV creation that errors, then skip that process and use
the table directly. ( i still need to determine if PowerMart can read an
access table, but i'd think it could..) SO the problem is running something
that identifies which MDB contains a specific table and renaming the MDB into
a common name "ABC.MDB" so powermart finds the table it is looking for.
Thanks for any thoughts! ( i don't have the power to increase the memory on
the offending machine)
Rob
I have a commercial application that generates an access .MDB which contains
a table with a specific name. The .MDB name is random, such as..
wsT3673085907.mdb. We may get several of these .mdb with different names.
I'd like to be able to run some command line process that will tell me
whether any of these contain a specific table "ABC".
More details if you're interested. The commecial package also genearate a
CSV file from table "ABC". For some reason ( I think it may be memory
related) the CSV generation fails and someone gets called to manually rerun
the report that failed. MY thought is, if the table is generated correctly,
and it is only the CSV creation that errors, then skip that process and use
the table directly. ( i still need to determine if PowerMart can read an
access table, but i'd think it could..) SO the problem is running something
that identifies which MDB contains a specific table and renaming the MDB into
a common name "ABC.MDB" so powermart finds the table it is looking for.
Thanks for any thoughts! ( i don't have the power to increase the memory on
the offending machine)
Rob