04 May 2004, How to change parameters of Import Specification through VBA Code

[Sham Yemul]

Hello,

I developed a software to import data to Access2002 tables and use it. I
created Import specification. The input file is in Text format of comma
separated values type(.csv).
I am facing problem to import data since the Text Identifier is
sometimes {none} sometimes double quote("). Right now , I saved another
specification that assumes double quote as string identifier. I change the
name of import specification at run-time based on user's choice. But I
wanted to know , Is there any way to set these values through code(VBA) so
that I can change the template run-time.

Thanks for spending time for me.

Regards
[Sham Shrinivas Yemul]

--***********************************************
Intellisoft Computer Consultants Pvt. Ltd.
340 A Sakhar peth, Solapur - 413005
Phone : 91-(0)217-262 4713
http:\\intellisoft.netfirms.com
Email : (e-mail address removed)
***********************************************

 

[Pieter Wijnen]

Yes,
MSysIMEXSpecs & MSysIMEXColumns
system tables

personally I don't like csv files (, + ") as you have difficulties importing
anything where " and , can be part of the data...
much better to use tab-separated fields or fixed width

hth
Pieter

Hello,

I developed a software to import data to Access2002 tables and use it. I
created Import specification. The input file is in Text format of comma
separated values type(.csv).
I am facing problem to import data since the Text Identifier is
sometimes {none} sometimes double quote("). Right now , I saved another
specification that assumes double quote as string identifier. I change the
name of import specification at run-time based on user's choice. But I
wanted to know , Is there any way to set these values through code(VBA) so
that I can change the template run-time.

Thanks for spending time for me.

Regards
[Sham Shrinivas Yemul]

--***********************************************
Intellisoft Computer Consultants Pvt. Ltd.
340 A Sakhar peth, Solapur - 413005
Phone : 91-(0)217-262 4713
http:\\intellisoft.netfirms.com
Email : (e-mail address removed)
***********************************************