AutoNumber

[Ben]

Hi all,

I created an import spec for a csv/txt file, but each time I open the
import spec, and imports the data file, it also created an id column,
which I don't need. I am curious is there a way to turn that off? I
tried to look around in the import spec and I don't see any. Thanks for
sharing your thoughts.

Ben

 

[Jack Leach]

In the DoCmd.TransferText method there sould be an option to include/exclude
an autonumber.


hth
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

 

[Ben]

Jack,
Thanks for your help.

Ben

 

[Jack Leach]

Hopefully I'm correct in my assumtion... it was off the top of my head and I
haven't verified it, but if I remeber correctly there's a whole slew of
arguments for various format handling in most of the DoCmd.Transfer*()
functions.

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)