Using import/export specs with ADP projects

[Alok]

Hi,
I recently upsized my access database to an ADP project with SQL
backend. However when I did it the import/export specs were not ported
to the new database. Also in the ADP files I am unable to create new
import/export specs. The option is greyed out. I need to use the specs
with the TransferText function.

How can I get around this issue?

Alok

[Michael \(michka\) Kaplan [MS]]

See

http://trigeminal.com/utility.asp?ItemID=4

for the tool to do this.

--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Alok" <al*********@ya hoo.com> wrote in message
news:dc******** *************** ***@posting.goo gle.com...

Hi,
I recently upsized my access database to an ADP project with SQL
backend. However when I did it the import/export specs were not ported
to the new database. Also in the ADP files I am unable to create new
import/export specs. The option is greyed out. I need to use the specs
with the TransferText function.

How can I get around this issue?

Alok

[Jerry Boone]

I haven't tried Michael's tool - but it sounds interesting.

I would use SQL servers DTS for this stuff. There is even a wizard you can
use to get started, then set it up on a schedule. DTS is very powerful and
is often overlooked. There is a great book on it if you are interested --
"SQL Server 2000 DTS".

:)

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
"Alok" <al*********@ya hoo.com> wrote in message
news:dc******** *************** ***@posting.goo gle.com...

Hi,
I recently upsized my access database to an ADP project with SQL
backend. However when I did it the import/export specs were not ported
to the new database. Also in the ADP files I am unable to create new
import/export specs. The option is greyed out. I need to use the specs
with the TransferText function.

How can I get around this issue?

Alok