Syntax Problem

[Guest]

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

 

[Steve Schapel]

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.

 

[Guest]

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]

Bill,

Thanks for the further information. However, I think you missed my
point. The Destination argument is supposed to be the name of the table
you are exporting to. Is Canutillo.Oae the name of a table in the
Access database you are exporting to? If so, it is not recommended to
put a . in a table name, in fact as far as I know Access won't allow it.

You might comment also on some of the other questions I raised.

 

[Guest]

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.

 

[Steve Schapel]

Bill,

The Microsoft Snapshot format is an image file. It is the native format
for export from Access, and is most often used for Reports, though you
can certainly use it for table datasheets. If you try an OutputTo
action in your macro, you should see it listed as an option under the
Output Format argument. This will be very easy, but I find it bizarre
that this is one of the 3 acceptable formats.

If you could find the required delimiter character, I think with a bit
of fiddling you could also export to a delimited file. Probably you
would have to export to a .txt file name, and then rename the file
afterwards. In Access you would use the TransferText action in a macro,
which mimics the process of exporting manually via the File|Export menu.

I do not know what an "Oracle compatible file" means. Posting a
follow-up question to the microsoft.public.access.externaldata newsgroup
might find someone with experience with this.

Good luck!

 

[Ken Snell \(MVP\)]

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.

 

[Guest]

Bill;
As an educator it is difficult to explain some things to non-educators.
I am currently working with Microsoft to set up a user's group for educators
with litttle IT experience. The school district I am with is the largest in
the US.

Both Ken and Steve are correct in what they are telling you. You must
use the Transfer Text to send the test results to CBOE if you are on Windows
XP.

Windows 2000 has some weird situations when referenced from an asp or
htm page. Try to use Transfer text first. If your original application was
written before Office 2000 try writing a macro using Output To as the primary
operation.

If it was written for Office 97 and was directed to a pdf file it will
take some effort. You must use Transfer Text and Export your table using
Fixed Width. The oae extension will recognize that and accept it. When
Microsoft introduced their Shapshot file it was great for us unless your site
was working pre 2000.

I apologize that I do not know more about Transfet Text as it has been
years since I worked with it last. Remember export your table as Fixed Width.

Good Luck

Len