469,953 Members | 2,235 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,953 developers. It's quick & easy.

Using import/export specs with ADP projects

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
Nov 12 '05 #1
2 3505
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*********@yahoo.com> wrote in message
news:dc**************************@posting.google.c om...
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

Nov 12 '05 #2
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*********@yahoo.com> wrote in message
news:dc**************************@posting.google.c om...
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Trev | last post: by
13 posts views Thread by (Pete Cresswell) | last post: by
1 post views Thread by PeteCresswell | last post: by
10 posts views Thread by Niklas | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.