Re: Text file SCHEMA

Hi Paul,

Thanks for your immediate reply.

Please find below are the lines from my text file.

DRIVER_CODE^SRC_KEY^TRG_KEY^NAME^SSN
PYDEDPYC01^ ^1446805230003^SWAMINATHAN ^25684654

When I am importing the above information into my access table the
spaces in the fields SRC_KEY and NAME are getting trimmed.

Help me for this scenario.

Thanks

Swaminathan.


Paul Clement wrote:
On 6 Dec 2006 07:38:45 -0800, swaminathan.mn@xxxxxxxxx wrote:

¤ Hi,
¤
¤ I have a problem that I am importing a delimited text file into access
¤ table using schema, but when I import all the spaces are trimmed in all
¤ the fields.
¤
¤ can anyone help me to import as it in the text file... ?
¤

Delimited text files don't generally contain spaces at the start or end of the values. Could you
post an example (a few lines from your text file) where the lines contain spaces?


Paul
~~~~
Microsoft MVP (Visual Basic)

.

Relevant Pages

  • Re: Text file SCHEMA
    ... ¤ Hi, ... I have a problem that I am importing a delimited text file into access ... table using schema, but when I import all the spaces are trimmed in all ... Microsoft MVP ...
    (microsoft.public.vb.database)
  • Re: RTF to ADO
    ... ¤ to import into an Access DB using ADO. ... I know I can convert them into TXT and XLS before importing them into ... How To Read and Write BLOBs Using GetChunk and AppendChunk ...
    (microsoft.public.vb.database.ado)
  • Re: reading text file using OLEDB into dataset
    ... ¤ 1)does the shema.ini should be in the same directory as the CSV file? ... I'm not sure what you mean by "use a stream as schema". ... each CSV file you have in the folder. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OpenSchema ADO VB adSchemaTables Schema parameter truncating from underscore
    ... By defining the "\" in ODBC it's working OK. ... ¤ the schema name from before the underscore. ... I have trioed with a schema without an '_' and this works fine. ... I am basically trying to retrieve SQL Tables from the relevant schema ...
    (microsoft.public.vb.database.ado)
  • Re: ConnectionString using DSN not working
    ... but you'll agree that the ODBC drivers do not ... support full functionality of target data providers. ... ¤ On Apr 18, 8:40 pm, Paul Clement ... ¤> Microsoft MVP ...
    (microsoft.public.dotnet.framework.adonet)
Loading