import text into table problem

  • Thread starter Thread starter nicolascaprais
  • Start date Start date
N

nicolascaprais

Hello, I use mS ACCESS 2002 on windows XP,



I want to automate the importation of multiple text files but an error
occurs when I run my Import text macro based on the text transfer
action. Indeed, Access asks me to choose the format (I use french
version sorry, it's the second row from top in the arguments of the text
transfer action, maybe it's named "Specification Name" I dunno...) from
a list but I get an empty list, therefore I don't know what to put...



I created a "schema.ini" file in the same folder as my txt file but
Access doesn't seem to use it... How can I tell it to do so or more
simply, how can I make it work?????



My fields are delimited with "µ" as I was sure this sign would'nt appear
anywhere in my text file. There are commas and spaces therefore Access
was gonna create thousands of fields...



I am in a dead end!!!

Here's my schema.ini code maybe it can help!!!



[Prop_Aero.txt]CharacterSet = ANSIFormat = Delimited(µ)Col1=Numéro IntegerCol2=Contact Person MemoCol3=Collaboration MemoCol4=Target Partner MemoCol5=Organisation MemoCol6=URL MemoCol7=Organisation Memo





thanks to anyone who can help



cheers

nico
 
Hi Nicolas,

Each item in schema.ini must be on a separate line, not in a single
string as it appeared in your message:

[Prop_Aero.txt]
CharacterSet = ANSI
Format = Delimited(µ)
Col1=Numéro Integer
Col2=Contact Person Memo
Col3=Collaboration Memo
Col4=Target Partner Memo
Col5=Organisation Memo
Col6=URL Memo
Col7=Organisation Memo

Also, in each field specification the fieldname must (as I understand
it) be a single argument. It's best never to use field names that
contain spaces, so I'd rename these fields, e.g.
Col2=ContactPerson Memo
but it may be possible to use
Col2=[Contact Person] Memo
or
Col2="Contact Person" Memo

You may find the documentation at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetsdk_98.asp
useful.


Hello, I use mS ACCESS 2002 on windows XP,



I want to automate the importation of multiple text files but an error
occurs when I run my Import text macro based on the text transfer
action. Indeed, Access asks me to choose the format (I use french
version sorry, it's the second row from top in the arguments of the text
transfer action, maybe it's named "Specification Name" I dunno...) from
a list but I get an empty list, therefore I don't know what to put...



I created a "schema.ini" file in the same folder as my txt file but
Access doesn't seem to use it... How can I tell it to do so or more
simply, how can I make it work?????



My fields are delimited with "µ" as I was sure this sign would'nt appear
anywhere in my text file. There are commas and spaces therefore Access
was gonna create thousands of fields...



I am in a dead end!!!

Here's my schema.ini code maybe it can help!!!



[Prop_Aero.txt]CharacterSet = ANSIFormat = Delimited(µ)Col1=Numéro IntegerCol2=Contact Person MemoCol3=Collaboration MemoCol4=Target Partner MemoCol5=Organisation MemoCol6=URL MemoCol7=Organisation Memo





thanks to anyone who can help



cheers

nico
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top