Greetings,
I'm using the DoCmd.TransferT ext method to export the results of a MS
Access query to a csv file. The csv will then be used to load an Oracle
table.
In other systems such as TOAD for Oracle, it's possible to force an
additional comma delimiter after the last column, if the column is empty
on a particular row. Oracle requires this additional comma on empty
rightmost columns, for importing purposes.
I am unable to see how to do this in the Visual Basic TransferText
method, or in the MS Access export specifications.
Can this be done in VB/Access, and how?
14  6418 
In your query, use a calculated field that looks like this:
RevisedLastFiel d:[LastFieldname] & ","
Uncheck the 'Show' box in the LastFieldName column and be sure the 'Show'
box is checked in the RevisedLastFiel d column. You want to export
RevisedLastFiel d rather than LastFieldName.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1150 users have come to me from the newsgroups requesting help re******@pcdata sheet.com
"bonehead" <se**********@h ere.net> wrote in message
news:e0******** **@gondor.sdsu. edu... Greetings,
I'm using the DoCmd.TransferT ext method to export the results of a MS
Access query to a csv file. The csv will then be used to load an Oracle
table.
In other systems such as TOAD for Oracle, it's possible to force an
additional comma delimiter after the last column, if the column is empty
on a particular row. Oracle requires this additional comma on empty
rightmost columns, for importing purposes.
I am unable to see how to do this in the Visual Basic TransferText method,
or in the MS Access export specifications.
Can this be done in VB/Access, and how?
bonehead <se**********@h ere.net> wrote in
news:e0******** **@gondor.sdsu. edu: Greetings,
I'm using the DoCmd.TransferT ext method to export the results
of a MS Access query to a csv file. The csv will then be used
to load an Oracle table.
In other systems such as TOAD for Oracle, it's possible to
force an additional comma delimiter after the last column, if
the column is empty on a particular row. Oracle requires this
additional comma on empty rightmost columns, for importing
purposes.
I am unable to see how to do this in the Visual Basic
TransferText method, or in the MS Access export
specifications.
Can this be done in VB/Access, and how?
Access always puts the correct number of commas. If you need an
additional comma at the end of every row, add null as the
expression for the calculated rightmost field in the query.
--
Bob Quintal
PA is y I've altered my email address.
"PCD" <no***@email.co m> schreef in bericht news:sg******** **********@news read1.news.atl. earthlink.net.. .
-- PC Datasheet
Your Resource For Help With Access, Excel And Word Applications 'Resource ????
Over 1150 users have come to me from the newsgroups requesting help '1150 users ????
re******@pcdata sheet.com
--
To Steve:
Over 575!! users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)
To the original poster:
Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.
Before you intend to do business with him look at: http://home.tiscali.nl/arracom/whoissteve.html
Arno R
All you are doing is INDEED showing every newsgroup reader that you are
nothing but an OBSESSED, egocentric A$$. You revel in tracking every post I
make in the newsgroups and do not make any contributions to our newsgroup.
Take the advise that was given to you by a poster not too long
ago and grow up and get a life. We don't need the likes of you in our
newsgroup! Just get lost and quit filling our newsgroup with your slanderous
garbage!!!!!!
INDEED!!!
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1150 users have come to me from the newsgroups requesting help re******@pcdata sheet.com
"StopThisAdvert ising" <StopThisAdvert ising@DataShit> wrote in message
news:44******** **************@ text.nova.plane t.nl...
"PCD" <no***@email.co m> schreef in bericht
news:sg******** **********@news read1.news.atl. earthlink.net.. .
-- PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
'Resource ????
Over 1150 users have come to me from the newsgroups requesting help
'1150 users ????
re******@pcdata sheet.com
--
To Steve:
Over 575!! users from the newsgroups have visited the website to read what
kind of a 'resource' you are... (rapidly increasing..)
To the original poster:
Most people here have a common belief that the newsgroups are for *free
exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell
his services.
Before you intend to do business with him look at: http://home.tiscali.nl/arracom/whoissteve.html
Arno R
What a "BONEHEAD" response!!!!
"Bob Quintal" <rq******@sympa tico.ca> wrote in message
news:Xn******** **************@ 207.35.177.135. .. bonehead <se**********@h ere.net> wrote in
news:e0******** **@gondor.sdsu. edu:
Greetings,
I'm using the DoCmd.TransferT ext method to export the results
of a MS Access query to a csv file. The csv will then be used
to load an Oracle table.
In other systems such as TOAD for Oracle, it's possible to
force an additional comma delimiter after the last column, if
the column is empty on a particular row. Oracle requires this
additional comma on empty rightmost columns, for importing
purposes.
I am unable to see how to do this in the Visual Basic
TransferText method, or in the MS Access export
specifications.
Can this be done in VB/Access, and how?
Access always puts the correct number of commas. If you need an
additional comma at the end of every row, add null as the
expression for the calculated rightmost field in the query.
--
Bob Quintal
PA is y I've altered my email address.
Why didn't you advise the OP to write one field at a time to his CSV file?
You thought that was the correct way to export a couple of hundred thousand
records to Excel!!
"Bob Quintal" <rq******@sympa tico.ca> wrote in message
news:Xn******** **************@ 207.35.177.135. .. bonehead <se**********@h ere.net> wrote in
news:e0******** **@gondor.sdsu. edu:
Greetings,
I'm using the DoCmd.TransferT ext method to export the results
of a MS Access query to a csv file. The csv will then be used
to load an Oracle table.
In other systems such as TOAD for Oracle, it's possible to
force an additional comma delimiter after the last column, if
the column is empty on a particular row. Oracle requires this
additional comma on empty rightmost columns, for importing
purposes.
I am unable to see how to do this in the Visual Basic
TransferText method, or in the MS Access export
specifications.
Can this be done in VB/Access, and how?
Access always puts the correct number of commas. If you need an
additional comma at the end of every row, add null as the
expression for the calculated rightmost field in the query.
--
Bob Quintal
PA is y I've altered my email address.
"PCD" <no***@email.co m> wrote in
news:In******** ***********@new sread1.news.atl .earthlink.net: Why didn't you advise the OP to write one field at a time to
his CSV file? You thought that was the correct way to export a
couple of hundred thousand records to Excel!!
Look, Pretty Crappy Developer (PCD), I offered a solution that
met all the constraints.It' s not the fastest, but it would work.
Code which satisfies customer requirements without errors is
always the correct way.
It's also obvious to me that you lack the knowledge that you can
write field by field to Excel when the transferSpreads heet
method fails.
Let us see some code for your solution which would properly
execute writing a single recordset to multiple Excel worksheets.
As for your suggestion in this thread, it has a bug.
If the export specification requires a text qualifier
RevisedLastFiel d:[LastFieldname] & ","
returns "PCD messed up," instead of "PCD messed up",
Put your money where your mouth is.
"Bob Quintal" <rq******@sympa tico.ca> wrote in message
news:Xn******** **************@ 207.35.177.135. .. bonehead <se**********@h ere.net> wrote in
news:e0******** **@gondor.sdsu. edu:
Greetings,
I'm using the DoCmd.TransferT ext method to export the
results of a MS Access query to a csv file. The csv will
then be used to load an Oracle table.
In other systems such as TOAD for Oracle, it's possible to
force an additional comma delimiter after the last column,
if the column is empty on a particular row. Oracle requires
this additional comma on empty rightmost columns, for
importing purposes.
I am unable to see how to do this in the Visual Basic
TransferText method, or in the MS Access export
specifications.
Can this be done in VB/Access, and how?
Access always puts the correct number of commas. If you need
an additional comma at the end of every row, add null as the
expression for the calculated rightmost field in the query.
--
Bob Quintal
PA is y I've altered my email address.
--
Bob Quintal
PA is y I've altered my email address.
Bob Quintal wrote: "PCD" <no***@email.co m> wrote in
news:In******** ***********@new sread1.news.atl .earthlink.net:
Why didn't you advise the OP to write one field at a time to
his CSV file? You thought that was the correct way to export a
couple of hundred thousand records to Excel!!
Look, Pretty Crappy Developer (PCD), I offered a solution that
met all the constraints.It' s not the fastest, but it would work.
Code which satisfies customer requirements without errors is
always the correct way.
It's also obvious to me that you lack the knowledge that you can
write field by field to Excel when the transferSpreads heet
method fails.
Let us see some code for your solution which would properly
execute writing a single recordset to multiple Excel worksheets.
As for your suggestion in this thread, it has a bug.
If the export specification requires a text qualifier
RevisedLastFiel d:[LastFieldname] & ","
returns "PCD messed up," instead of "PCD messed up",
Put your money where your mouth is.
Access always puts the correct number of commas. If you need
an additional comma at the end of every row, add null as the
expression for the calculated rightmost field in the query.
--
Bob Quintal
PA is y I've altered my email address.
Bob,
We're all trying to keep this PCD mess as unobtrusive as is practical, I
suspect that's why no one has responded. I felt, however, it was
justified in this case.
I certainly noted, and suspect most everyone else did, that in both
cases referenced here, you offered a solution that would work, and
neither of PCD's would have.
--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.
Randy Harris <pl****@send.no .spam> wrote in
news:bJ******** **********@news svr14.news.prod igy.com: Bob Quintal wrote: "PCD" <no***@email.co m> wrote in
news:In******** ***********@new sread1.news.atl .earthlink.net:
Why didn't you advise the OP to write one field at a time to
his CSV file? You thought that was the correct way to export
a couple of hundred thousand records to Excel!!
Look, Pretty Crappy Developer (PCD), I offered a solution
that met all the constraints.It' s not the fastest, but it
would work. Code which satisfies customer requirements
without errors is always the correct way.
It's also obvious to me that you lack the knowledge that you
can write field by field to Excel when the
transferSpreads heet method fails.
Let us see some code for your solution which would properly
execute writing a single recordset to multiple Excel
worksheets.
As for your suggestion in this thread, it has a bug.
If the export specification requires a text qualifier
RevisedLastFiel d:[LastFieldname] & ","
returns "PCD messed up," instead of "PCD messed up",
Put your money where your mouth is.
>
Access always puts the correct number of commas. If you
need an additional comma at the end of every row, add null
as the expression for the calculated rightmost field in the
query.
--
Bob Quintal
PA is y I've altered my email address.
Bob,
We're all trying to keep this PCD mess as unobtrusive as is
practical, I suspect that's why no one has responded. I felt,
however, it was justified in this case.
I certainly noted, and suspect most everyone else did, that in
both cases referenced here, you offered a solution that would
work, and neither of PCD's would have.
Randy, I don't wanna fan any flames either, but when Pretty
Crummy Developer (PCD) starts posting wrong information, I try
to post a working solution, if I know of one. I'll limit myself
to that. I'm sure people come looking for 'working' solutions.
There is no information worse than wrong information.
--
Bob Quintal
PA is y I've altered my email address. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Alberto Vera |
last post by:
Hello:
I have the next structure:
How Can I make it using Python?
How Can I update the value of 6?
|
by: atse |
last post by:
Hi experts,
I retrieve data from the database and display on ASP, then I export these
data to a file, like Excel (the best) or text file. Is it possible? I think
it is possible, but how can I do that? Thanks for any help.
Atse
|
by: Tim Eliot |
last post by:
Just wondering if anyone has hit the following issue and how you might
have sorted it out.
I am using the command:
DoCmd.TransferText acExportMerge, , stDataSource, stFileName, True
after setting stDataSource and stFileName to the desired values. Most
of the time it works, but occasionally, typically as code changes are
being made to...
|
by: cab2 |
last post by:
We currently have an application built in Access that takes in a csv
file using docmd.transfertext. We allow users to export their data to
a file for later use (csv format). Users are also allowed to re-import
their archived data. This all works fine, until we have to update the
application for international users. The original csv files...
|
by: mattc66 via AccessMonster.com |
last post by:
I need to create an EDI 850 Record Set.
The EDI 850 Record set I am creating consists of 2-5 seperate tables all
linked by the CustomerID and CustomerPO.
Tables -
tblOrder - >Link CustomerID and CustomerPO
-RecordType
-CustomerID ->
-OrderDate
| | |
by: no_spam_for_gman |
last post by:
I have been using the export command for quite some times to export
comma delimited file. I have always been looking at how to generate
the first row with the column header but never found a clean way to do
it. I have searched this newsgroup and the only suggestion found was
to cast all column to strings and do a union, or to add the first...
|
by: colleen1980 |
last post by:
Hi:
Can any one please tell me how to i export data thru VBA code as same
when i right click on any table and then it ask me to export data as
comma delimited. Can i do the same thru VBA code. I need it not prompt
me for comma delimited or fixed length as i only need the comma
delimited text. It automatically convert the table into comma...
|
by: NEWSGROUPS |
last post by:
I have data in a table in an Access 2000 database that needs to be exported
to a formatted text file. For instance, the first field is an account number
that is formatted in the table as text and is 8 characters long. This field
needs to be exported as pic(15) padded in the front with 0's (zeros). The
next field an ID name that is 15...
|
by: Jan Sneeuwman |
last post by:
Hello,
I am working on a library in C++, and the library goes with a header file
with a trailing comma at the end of some enumeration. Like this:
enum Abc {
ENUM_ONE,
ENUM_TWO
ENUM_THREE,
#ifdef HAVE_SOMETHING
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
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...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
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...
|
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...
|
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
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
