IM/EXport specifications automatically creating

[Scott Simonson]

Does anyone know of a way to create import/export specifications via code? I
want my users to able to create a table when needed but in order to allow
importing into and exporting out of I need these specifications in place.
I'd like to have it automatic somehow, possibly through a button.

Thanks

[Tom van Stiphout]

On Sat, 5 Feb 2005 08:33:12 -0600, "Scott Simonson"
<sc***********@wi.rr.com> wrote:

They are stored in some hidden MSys* tables. They are undocumented,
but not too hard to figure out.

-Tom.

Does anyone know of a way to create import/export specifications via code? I
want my users to able to create a table when needed but in order to allow
importing into and exporting out of I need these specifications in place.
I'd like to have it automatic somehow, possibly through a button.

Thanks

[Scott Simonson]

I looked at the MSys*Spec table and am not sure about one field. I know you
said undocumented but does anyone have any idea of what field is [FileType]
and what possible values may exist?

Thanks

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:kh********************************@4ax.com...

On Sat, 5 Feb 2005 08:33:12 -0600, "Scott Simonson"
<sc***********@wi.rr.com> wrote:

They are stored in some hidden MSys* tables. They are undocumented,
but not too hard to figure out.

-Tom.

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In the table MSysIMEXSpecs, the column FileType can have the following
values:

Name Value
================== =====
Windows (ANSI) 0
DOS or OS/2 (PC-8) 1

What do they mean? Don't know. They, obviously, refer to Text files.
Try creating an export spec. and export a table/query in both FileTypes.
See how they differ.

I created an import/export add-in in Access 97. It is available at:

http://home.earthlink.net/~mgf00/

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQgWDH4echKqOuFEgEQIq7QCg1KI2gdoZeAmwtZbGLrZdhf 4DS7gAoNsO
uBNvawEWAGiYg9AGkqZ8cNrR
=zJhd
-----END PGP SIGNATURE-----
Scott Simonson wrote:

I looked at the MSys*Spec table and am not sure about one field. I know you
said undocumented but does anyone have any idea of what field is [FileType]
and what possible values may exist?

Thanks

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:kh********************************@4ax.com...

On Sat, 5 Feb 2005 08:33:12 -0600, "Scott Simonson"
<sc***********@wi.rr.com> wrote:

They are stored in some hidden MSys* tables. They are undocumented,
but not too hard to figure out.

-Tom.

[Tom van Stiphout]

On Sat, 05 Feb 2005 23:49:18 GMT, "Scott Simonson"
<sc***********@wi.rr.com> wrote:

I don't, but if I needed to find out, I would speculate it is some ID
value for the kind of file it is: text, Excel, etc, and create a few
import specs to see what values would be used.

-Tom.

I looked at the MSys*Spec table and am not sure about one field. I know you
said undocumented but does anyone have any idea of what field is [FileType]
and what possible values may exist?

Thanks

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:kh********************************@4ax.com.. .

On Sat, 5 Feb 2005 08:33:12 -0600, "Scott Simonson"
<sc***********@wi.rr.com> wrote:

They are stored in some hidden MSys* tables. They are undocumented,
but not too hard to figure out.

-Tom.

[Michael \(michka\) Kaplan [MS]]

In Jet 4.0 and later, it is the code page to use -- you can specify any code
page there, not just 0 or 1.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Technical Lead
Globalization Infrastructure, Fonts, and Tools
Microsoft Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.
"MGFoster" <[e-mail]> wrote in message
news:sq****************@newsread1.news.pas.earthli nk.net...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In the table MSysIMEXSpecs, the column FileType can have the following
values:

Name Value
================== =====
Windows (ANSI) 0
DOS or OS/2 (PC-8) 1

What do they mean? Don't know. They, obviously, refer to Text files.
Try creating an export spec. and export a table/query in both FileTypes.
See how they differ.

I created an import/export add-in in Access 97. It is available at:

http://home.earthlink.net/~mgf00/

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQgWDH4echKqOuFEgEQIq7QCg1KI2gdoZeAmwtZbGLrZdhf 4DS7gAoNsO
uBNvawEWAGiYg9AGkqZ8cNrR
=zJhd
-----END PGP SIGNATURE-----
Scott Simonson wrote:

I looked at the MSys*Spec table and am not sure about one field. I know you said undocumented but does anyone have any idea of what field is [FileType] and what possible values may exist?

Thanks

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:kh********************************@4ax.com...

On Sat, 5 Feb 2005 08:33:12 -0600, "Scott Simonson"
<sc***********@wi.rr.com> wrote:

They are stored in some hidden MSys* tables. They are undocumented,
but not too hard to figure out.

-Tom.