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
4  2447 
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.TransferT ext
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
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 FileSystemObjec t 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.TransferT ext
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
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 FileSystemObjec t 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
specificatio n. Just step through the export wizard and you'll get the
option to save.
If your requirements are modest, you can also use DoCmd.TransferT ext
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
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 FileSystemObjec t 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.TransferT ext
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Job Lot |
last post by:
Using VB.NET how can I convert access table to tab delimited text file?
Thanks
|
by: Ben |
last post by:
Hi all -
I am having a bit of trouble and thought maybe someone in this group
could shed some light. Here's the skinny...
I am creating an automated process to import a bunch of text files
into Access. I want to avoid creating a separate "Spec" for each file
(there are over 180 files) and instead want to code my own dynamic
importing rules. So far it's been going fine, except for one item...
|
by: nunYa |
last post by:
I am trying to use the DoCmd.TransferText method to export an access table
to
a Tab Delimited Text File. I have put the code behind the onclick event of
a button
and keep getting the error "Run-time error '32027': Cannot update. Database
or object is read-only"
Code I using is:
Private Sub ExportButton_Click()
|
by: Kenneth Koski |
last post by:
Hello All,
I have a comma delimited text file, which I would like to move into a
SQL 2000 table . I created a DTS package in SQL Server and saved it as a
VB.bas . I am writting the code in C# and I though that I might be able
to change a few lines and keep the bulk of the code. However , it seems
that there is a pretty big change in how VB is written and how C#.net is
written. Does anyone have an example of using DTS and C# to move a few...
|
by: Joe Fisherman |
last post by:
I have used regex to parse a huge text file, and grab a tab delimited
portion of it. I often use comma delimited text files, and use Jet Oledb4.
I read that I would need an ini if the file wasn't comma delimited - if
this is true, I am not sure of the easiest process to create an ini. The
string has a header.
My string looks like:
"Call" "Date" "Time" "Call Period" "From" "Call Type"
"Number Called" "To" "Call Length" "Local Airtime...
| | |
by: jjturon |
last post by:
Can anyone help me??
I am trying to pass a Select Query variable to a table using Dlookup
and return the value to same select query but to another field.
Ex.
SalesManID SalesManName
AT Alan Time
|
by: raju5725 |
last post by:
have a MS access table and I want to export it to comma delimited
text file. How do I do this programmatically using VB.NET or C#?
Thanks for any help in advance.
Raju
|
by: RadhakrishnanR |
last post by:
Hi,
By using VB6.0, I want to export database table data into (i.e based on the selected file type(xls or txt)) excel file or text file with a tab delimited text file.
My User interface has:
• Drop down list box contain list of data base table name.
• A path selection area, allowing the user to specify the filename, path and file type for the
export. This will incorporate standard Windows functionality for allowing the user...
|
by: wisaunders |
last post by:
the file I'm importing has > 200,000 records
I have one problem:
One of the columns in the .txt file (customerID) has almost all Inetger values except for about 30 records. Those 30 records have one letter in the customerID field (M123456). The field they are going into is VARCHAR(1000) . All of the integers go in correctly but for some reason the cutomerID values that stert with a letter (M123456) are NULL.
Any help? I'm stumped.
...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
