471,093 Members | 1,976 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,093 software developers and data experts.

table from .ADP to tab delimited text file

hello cdma enthusiasts. long time no speak. i have an .adp which is
connected to a sql 2k back end from which i need to export a table to
a tab delimited text file. the export text wizard apparently doesn't
allow you to store export specs (makes sense since it has no local
storage) so i'm not sure the TransferText method is going to do the
trick. i need to do this in VBA. any suggestions?

it's been a while since i've been active in cdma and the last i
remember there weren't a lot of people discussing ADPs. i think Steve
Jorgenson and Lyle were using them quite a bit so i'm hoping someone
has encountered this. right now i'm automating excel to get this done
which works but is sorta clumsy. TIA.

Ted
Dec 4 '07 #1
4 2325
On Mon, 3 Dec 2007 18:45:45 -0800 (PST), Ted Theo <te*****@gmail.com>
wrote:

Au contraire, the export wizard *does* allow you to save an export
specification. Just step through the export wizard and you'll get the
option to save.
If your requirements are modest, you can also use DoCmd.TransferText
without an export specification.

Lyle is still here. Haven't heard from Steve in a while.

-Tom.

>hello cdma enthusiasts. long time no speak. i have an .adp which is
connected to a sql 2k back end from which i need to export a table to
a tab delimited text file. the export text wizard apparently doesn't
allow you to store export specs (makes sense since it has no local
storage) so i'm not sure the TransferText method is going to do the
trick. i need to do this in VBA. any suggestions?

it's been a while since i've been active in cdma and the last i
remember there weren't a lot of people discussing ADPs. i think Steve
Jorgenson and Lyle were using them quite a bit so i'm hoping someone
has encountered this. right now i'm automating excel to get this done
which works but is sorta clumsy. TIA.

Ted
Dec 4 '07 #2
hmm, i must be doing something wrong then because i'm not given the
option to save the specs. you are talking about an ADP correct?
since data projects don't have any local storage where would the specs
be stored? i've seen a few references to using a FileSystemObject but
haven't run across any sample code. again, i can get there by dumping
it to excel and then using automation to save it out but that just
doesn't seem like the best approach.

good to hear some of the usual suspects are still around. it's a
shame steve isn't. he really knew ADPs. i appreciate any feedback
you guys may have.

On Dec 3, 10:35 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Mon, 3 Dec 2007 18:45:45 -0800 (PST), Ted Theo <tedt...@gmail.com>
wrote:

Au contraire, the export wizard *does* allow you to save an export
specification. Just step through the export wizard and you'll get the
option to save.
If your requirements are modest, you can also use DoCmd.TransferText
without an export specification.

Lyle is still here. Haven't heard from Steve in a while.

-Tom.
hello cdma enthusiasts. long time no speak. i have an .adp which is
connected to a sql 2k back end from which i need to export a table to
a tab delimited text file. the export text wizard apparently doesn't
allow you to store export specs (makes sense since it has no local
storage) so i'm not sure the TransferText method is going to do the
trick. i need to do this in VBA. any suggestions?
it's been a while since i've been active in cdma and the last i
remember there weren't a lot of people discussing ADPs. i think Steve
Jorgenson and Lyle were using them quite a bit so i'm hoping someone
has encountered this. right now i'm automating excel to get this done
which works but is sorta clumsy. TIA.
Ted


Dec 4 '07 #3
On Mon, 3 Dec 2007 20:09:57 -0800 (PST), Ted Theo <te*****@gmail.com>
wrote:

I was in an A2002/2003 format ADP in A2007.
I'm assuming the specs are stored in one of the sys* tables on SQL
Server.

-Tom.

>hmm, i must be doing something wrong then because i'm not given the
option to save the specs. you are talking about an ADP correct?
since data projects don't have any local storage where would the specs
be stored? i've seen a few references to using a FileSystemObject but
haven't run across any sample code. again, i can get there by dumping
it to excel and then using automation to save it out but that just
doesn't seem like the best approach.

good to hear some of the usual suspects are still around. it's a
shame steve isn't. he really knew ADPs. i appreciate any feedback
you guys may have.

On Dec 3, 10:35 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
>On Mon, 3 Dec 2007 18:45:45 -0800 (PST), Ted Theo <tedt...@gmail.com>
wrote:

Au contraire, the export wizard *does* allow you to save an export
specification. Just step through the export wizard and you'll get the
option to save.
If your requirements are modest, you can also use DoCmd.TransferText
without an export specification.

Lyle is still here. Haven't heard from Steve in a while.

-Tom.
>hello cdma enthusiasts. long time no speak. i have an .adp which is
connected to a sql 2k back end from which i need to export a table to
a tab delimited text file. the export text wizard apparently doesn't
allow you to store export specs (makes sense since it has no local
storage) so i'm not sure the TransferText method is going to do the
trick. i need to do this in VBA. any suggestions?
>it's been a while since i've been active in cdma and the last i
remember there weren't a lot of people discussing ADPs. i think Steve
Jorgenson and Lyle were using them quite a bit so i'm hoping someone
has encountered this. right now i'm automating excel to get this done
which works but is sorta clumsy. TIA.
>Ted

Dec 4 '07 #4
i probably should have specified that i'm using 2003 but it doesn't
work for me in 2000 or 2002. i don't think that access doesn't add
any tables to the SQL database you use as your data source. i've also
seen several posts w/people saying they can't save im/ex specs in ADPs
so maybe that's something new in 2007.

maybe automating Excel to save a table as a tab delimited file isn't
as clumsy as i thought. this app has a few dozen users and they all
have Excel. i was just hoping for a better way.

On Dec 4, 8:01 am, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Mon, 3 Dec 2007 20:09:57 -0800 (PST), Ted Theo <tedt...@gmail.com>
wrote:

I was in an A2002/2003 format ADP in A2007.
I'm assuming the specs are stored in one of the sys* tables on SQL
Server.

-Tom.
hmm, i must be doing something wrong then because i'm not given the
option to save the specs. you are talking about an ADP correct?
since data projects don't have any local storage where would the specs
be stored? i've seen a few references to using a FileSystemObject but
haven't run across any sample code. again, i can get there by dumping
it to excel and then using automation to save it out but that just
doesn't seem like the best approach.
good to hear some of the usual suspects are still around. it's a
shame steve isn't. he really knew ADPs. i appreciate any feedback
you guys may have.
On Dec 3, 10:35 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Mon, 3 Dec 2007 18:45:45 -0800 (PST), Ted Theo <tedt...@gmail.com>
wrote:
Au contraire, the export wizard *does* allow you to save an export
specification. Just step through the export wizard and you'll get the
option to save.
If your requirements are modest, you can also use DoCmd.TransferText
without an export specification.
Lyle is still here. Haven't heard from Steve in a while.
-Tom.

>hello cdma enthusiasts. long time no speak. i have an .adp
which is
connected to a sql 2k back end from which i need to export a table to
a tab delimited text file. the export text wizard apparently doesn't
allow you to store export specs (makes sense since it has no local
storage) so i'm not sure the TransferText method is going to do the
trick. i need to do this in VBA. any suggestions?
it's been a while since i've been active in cdma and the last i
remember there weren't a lot of people discussing ADPs. i think Steve
Jorgenson and Lyle were using them quite a bit so i'm hoping someone
has encountered this. right now i'm automating excel to get this done
which works but is sorta clumsy. TIA.
Ted
Dec 4 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Job Lot | last post: by
3 posts views Thread by Joe Fisherman | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.