Import ASCII Data

I have data that comes from a legacy system. I can obtain the data in an
ASCII format. Currently I have created scripts in ACCESS to import the data
into tables.

What I would like to do is create an automated import function in SQL.

I am new to SQL, can anyone point me in the direction I should look to find
out how I could perform this task?

Using SQL 2005.

Thanks
Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via http://www.sqlmonster.com

.

Relevant Pages

  • Re: creating unique index and clustered index in sql server management studio
    ... Anything more should be done thru the Generate Scripts ... Andrew J. Kelly SQL MVP ... > SQL 2000 GUI created the indexes by creating a constraint while the new ... >>> Then the changes work and the code is genereted in the scripts. ...
    (microsoft.public.sqlserver.tools)
  • Re: Help Understanding mx.ODBC Error
    ... running the scripts on old data (that these scripts were able to digest ... Greg Corradini wrote: ... But recently they continue to bail on the mycursor.execute('An SQL ... Sent from the Python - python-list mailing list archive at Nabble.com. ...
    (comp.lang.python)
  • Re: Help Understanding mx.ODBC Error
    ... Greg Corradini wrote: ... I wrote two scripts using mx.ODBC on an Access DB. ... But recently they continue to bail on the mycursor.execute('An SQL ... I used the proper parameterization with "?" ...
    (comp.lang.python)
  • RE: Making Temp Tables with ODBC
    ... a passthrough without having to use the Straight SQL. ... Try writing the SQL statement in the legacy system and then copying & ... via ODBC and use regular Access queries instead of passthrough queries. ...
    (microsoft.public.access.externaldata)
  • Index server not displaying results (random directories)
    ... strictly the SQL statement and the directory and write DESC ... to display files in a certain directory with extra parameters like ' ... filename like "01 04" added to the SQL and write DESC ... yet the scripts and directory structures and filenames are ALWAYS ...
    (microsoft.public.inetserver.indexserver)