Tags: access, cansomebody, code, csv, database, enables, file, flat, load, microsoft, mysql, oracle, provide, sql, t000, table, thisfile, vba

VBA Code to load data from a file into a Access table

On Database » Microsoft Access

941 words with 1 Comments; publish: Sun, 01 Jun 2008 12:18:00 GMT; (25062.50, « »)

I have an Access table T000 and a flat file T000.csv in c:\data can

somebody please provide me the VBA code that enables me to load this

file into the above table.

Similarly a VBA code to take data from table t000 and place it into

unloadt000.csv in c:\temp

Thanks

Karen

All Comments

Leave a comment...

  • 1 Comments
    • Check out TransferText in Help. It'll do what you want, both for importing

      and exporting data.

      Ken Snell

      <MS ACCESS MVP>

      "Karen Middleton" <karenmiddleol.ms-access.todaysummary.com.yahoo.com> wrote in message

      news:a5fd468a.0412210437.7b9b13f7.ms-access.todaysummary.com.posting.google.c om...

      >I have an Access table T000 and a flat file T000.csv in c:\data can

      > somebody please provide me the VBA code that enables me to load this

      > file into the above table.

      > Similarly a VBA code to take data from table t000 and place it into

      > unloadt000.csv in c:\temp

      > Thanks

      > Karen

      #1; Sun, 01 Jun 2008 12:19:00 GMT