How do I create an import template without an automatic primary key created?
When I create my template to bring in a text file that is comma seperated, I
created the template and saved it, but when I click finish, the table is
created and has an auto generated ID field. Did I miss somewhere that I can
tell it not to create the autoID and save that as part of the import
template? I know if you go step by step through the process, you can tell it
not to create the ID field. I want to be able to use this template as part of
an automatic process running from within a macro. Also how do I run it from a
macro? I see there is an Action - RunCommand with the property of Import but
has no other properties to select the template I wish to use or point to a
file to import.
Thanks in advance
Kenny A.

Somewhere in the Import Text Wizard dialogs (which you used to create the
Import Specification), probably the 3rd or 4th dialog box, you have the
option of getting Access to generate the PrimaryKey Field ID or not.

To automate with Macros, use the TransferText Macro action.

--
HTH
Van T. Dinh
MVP (Access)



"Kenny A." <(E-Mail Removed)> wrote in message
news60E2BD3-6260-4A21-B30D-(E-Mail Removed)...
> How do I create an import template without an automatic primary key
> created?
> When I create my template to bring in a text file that is comma seperated,
> I
> created the template and saved it, but when I click finish, the table is
> created and has an auto generated ID field. Did I miss somewhere that I
> can
> tell it not to create the autoID and save that as part of the import
> template? I know if you go step by step through the process, you can tell
> it
> not to create the ID field. I want to be able to use this template as part
> of
> an automatic process running from within a macro. Also how do I run it
> from a
> macro? I see there is an Action - RunCommand with the property of Import
> but
> has no other properties to select the template I wish to use or point to a
> file to import.
> Thanks in advance
> Kenny A.

Van,
Thanks for replying. I know (as I mentioned in my original post) in the
wizard you can turn off the option to auto gen an ID field, but that does not
seem to get saved with the template. The template saved the field names and
size, type of field, but not the option of turning off auto gen of the ID
field. If I manually import the file and select the template, yes I can walk
through rest of steps to turn off auto gen of ID field, but if this is going
to run automatically, I will not have that option. So, again I ask, how to I
turn off this option and save as part of template that will run
automatically?
Thanks
Kenny A.

"Van T. Dinh" wrote:

> Somewhere in the Import Text Wizard dialogs (which you used to create the
> Import Specification), probably the 3rd or 4th dialog box, you have the
> option of getting Access to generate the PrimaryKey Field ID or not.
>
> To automate with Macros, use the TransferText Macro action.
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "Kenny A." <(E-Mail Removed)> wrote in message
> news60E2BD3-6260-4A21-B30D-(E-Mail Removed)...
> > How do I create an import template without an automatic primary key
> > created?
> > When I create my template to bring in a text file that is comma seperated,
> > I
> > created the template and saved it, but when I click finish, the table is
> > created and has an auto generated ID field. Did I miss somewhere that I
> > can
> > tell it not to create the autoID and save that as part of the import
> > template? I know if you go step by step through the process, you can tell
> > it
> > not to create the ID field. I want to be able to use this template as part
> > of
> > an automatic process running from within a macro. Also how do I run it
> > from a
> > macro? I see there is an Action - RunCommand with the property of Import
> > but
> > has no other properties to select the template I wish to use or point to a
> > file to import.
> > Thanks in advance
> > Kenny A.
>
>
>

In the TransferText Macro or TransferText Method (VBA), you have an option
to specify the Import Specification you want to use for the import.

Check carefully Access Help (Macro) / Avvess VB Help (Method) and you will
see this option, argument.

--
HTH
Van T. Dinh
MVP (Access)



"Kenny A." <(E-Mail Removed)> wrote in message
news:B9D4AF3C-AE80-4DD2-BE23-(E-Mail Removed)...
> Van,
> Thanks for replying. I know (as I mentioned in my original post) in the
> wizard you can turn off the option to auto gen an ID field, but that does
> not
> seem to get saved with the template. The template saved the field names
> and
> size, type of field, but not the option of turning off auto gen of the ID
> field. If I manually import the file and select the template, yes I can
> walk
> through rest of steps to turn off auto gen of ID field, but if this is
> going
> to run automatically, I will not have that option. So, again I ask, how
> to I
> turn off this option and save as part of template that will run
> automatically?
> Thanks
> Kenny A.
>

Thanks Van, I will look into.
Have a nice day

"Van T. Dinh" wrote:

> In the TransferText Macro or TransferText Method (VBA), you have an option
> to specify the Import Specification you want to use for the import.
>
> Check carefully Access Help (Macro) / Avvess VB Help (Method) and you will
> see this option, argument.
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "Kenny A." <(E-Mail Removed)> wrote in message
> news:B9D4AF3C-AE80-4DD2-BE23-(E-Mail Removed)...
> > Van,
> > Thanks for replying. I know (as I mentioned in my original post) in the
> > wizard you can turn off the option to auto gen an ID field, but that does
> > not
> > seem to get saved with the template. The template saved the field names
> > and
> > size, type of field, but not the option of turning off auto gen of the ID
> > field. If I manually import the file and select the template, yes I can
> > walk
> > through rest of steps to turn off auto gen of ID field, but if this is
> > going
> > to run automatically, I will not have that option. So, again I ask, how
> > to I
> > turn off this option and save as part of template that will run
> > automatically?
> > Thanks
> > Kenny A.
> >
>
>
>

You're welcome ... Good lucks with your project ...

--
Van T. Dinh
MVP (Access)



"Kenny A." <(E-Mail Removed)> wrote in message
news:E330AF08-18F5-42BC-B1FC-(E-Mail Removed)...
> Thanks Van, I will look into.
> Have a nice day
>