Re: Syntax Problem

Bill -

If we can identify the specific character that is the delimiter for the
"oae" file, that may be the best way to go.

ACCESS can create a text file (with a "txt" extension) fairly easily using
the TransferText option in a macro. You can create an export specification
to be used during the export that would specify the special delimiter. Then,
you would manually change the "txt" to "oae" before sending it to SAT.

Can you copy and paste the special delimiter character into a newsgroup post
so that we can identify the character? Then we can help you set up the
TransferText option.

--

Ken Snell
<MS ACCESS MVP>


"Bill Barber" <BillBarber@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:38B90604-0ED4-4DC0-9B55-4D9EBC8E74F1@xxxxxxxxxxxxxxxx
> Steve;
> Never worked with anything like this before. I have to export my
> table to one of three formats.
>
> To a Microsoft Snapshot file that I already spent five weeks
> researching and found nothing on.
>
> An OAE extension with a special delimiter (kind of looks like an
> upside down L in Open Office)
>
> An Oracle compatable flat file with an attached .pdf file. This is
> part of the new requirements of the new SAT tests if we want our disabled
> students to take them from their home.
>
> I have contacted as many people as I could with no results.
>
> Do you know if this can be done? I do a lot of research as a
> Computer Sciences Teacher but find little on databases and rarely get
> involved with databases. The school districts are too small to hire a
> full
> time programmer.
>
> Thanks for helping out.
>
>
>
>
> "Bill Barber" wrote:
>
>> Canutillo is our school district.
>> Oae is the extension requested by the College Board of Examiners in New
>> York
>> City.
>>
>> Thanks for getting back to me.
>>
>> "Steve Schapel" wrote:
>>
>> > Bill,
>> >
>> > What is Canutillo.Oae?
>> >
>> > The Database Name argument is the database you are exporting to. Is
>> > that C:\Guidance\SAT\Juniors.mdb?
>> >
>> > The Source argument should just show the name of the table, i.e.
>> > SATtests. C:\Guidance\SAT\Juniors.mdb\SATtests doesn't make sense
>> > anyway, but it also makes me suspect that Juniors.mdb is the local
>> > database you are exporting from, so it can't be the one you are
>> > exporting to, right? Sorry to dither, but I can't really see what you
>> > are trying to do here.
>> >
>> > --
>> > Steve Schapel, Microsoft Access MVP
>> >
>> >
>> > Bill Barber wrote:
>> > > The Halt I am Getting is that it cannot find my table which I know
>> > > exists?
>> > >
>> > > Transfer Type = Export
>> > > Database Type = Microsoft Access
>> > > Database Name = C:\Guidance\SAT\Juniors.mdb
>> > > Object Type = Table
>> > > Source = C:\Guidance\SAT\Juniors.mdb\SATtests
>> > > Destination = Canutillo.Oae
>> > > Structure Only = No
>> > >
>> > > Why is it not finding my Database Name? or Table SATtests
>> > >
>> > > I have been guessing all day! The Table is SATtests and the Database
>> > > Name is
>> > > Juniors.mdb
>> > >
>> > > What am I doing wrong?
>> > >
>> > > Thanks a lot
>> > >
>> > > Bill
>> >


.

Relevant Pages

  • Re: OpenSSH: spaces in user name
    ... Unruh> quotes and double quotes into my name. ... such a delimiter plays a very particular ... In your case you want it to either be a character in a name, ... humans but even more confusing to the computer. ...
    (comp.security.ssh)
  • Re: Loading a data file containing character fields with different encodings
    ... UTF-8 characters along with Latin-1 characters. ... One containing the latin-1 character set column, the second containing the utf-8 column and of course both files containing the primary key information. ... it would be just as easy to write the loader script that converts the encoding to a "unicode" intermediate format and then load with the correct database encoding. ... This caused that no conversion was done, but you were puting CP1252 characters into an 819 database! ...
    (comp.databases.informix)
  • Re: Are there performancebenefits to reorganizing database-using export/import?
    ... time we had done full export of 8.1.7 database and then created 9.2. ... those warnings are well defined in "Expert Oracle Database ... What happens if you accidentally change the character set when you ... exactly 30 characters long with an empty set character in the column ...
    (comp.databases.oracle.server)
  • Re: reading csv files
    ... >> stream, so, after the first name is extracted, the subsequent ... delimiter character, and not provide a complete solution to reading a CSV ... The next such call extracts 'yyyy', and ',', and the ...
    (alt.comp.lang.learn.c-cpp)
  • Re: Truncated string (still)
    ... > time the browser encounters a second ', it will take that to mean the end ... > use that character in the value. ... Or, if you use ' as the delimiter, you ... I will use the phrase Ray did use in his ...
    (microsoft.public.inetserver.asp.db)