By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,347 Members | 1,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,347 IT Pros & Developers. It's quick & easy.

IM/EXport specifications automatically creating

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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


Nov 13 '05 #2

P: n/a
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.

Nov 13 '05 #3

P: n/a
-----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.


Nov 13 '05 #4

P: n/a
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.


Nov 13 '05 #5

P: n/a
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" <me@privacy.com> 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.


Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.