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

Explore Related Content On "Microsoft Access"

• Hot Articles & Questions on "Microsoft Access"
• VBA code to load a form with specific record
• VBA code to get tables & fields in Access2000
• VBA Code to get data from 2 relational tables
• VBA code to fix key violation message
• VBA Code to find Duplicates in a Access Table
• vba code to duplicate edits on sub-form
• vba code to drop multiple tables at once
• VBA code to change the label text
• VBA code to capture Computer device unique ID number
• VBA Code to Add function while retrieving data to Excel

• Open Articles & Questions on "Microsoft Access"
• VBA Code To Insert jpeg file into power point
• VBA code to import data from an Excel sheet
• VBA Code to extract PDF stream from BMP (long)
• VBA code to export Access 2003 Table to XML
• VBA code to export Access 2003 Table to XML
• vba code to drop multiple tables at once
• VBA code to create multiple charts in a single Excel sheet Options
• VBA code to create multiple charts in a single Excel sheet
• VBA code to create a word merge
• VBA code to auto insert Word document OLE object

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.itags.org.yahoo.com> wrote in message

    news:a5fd468a.0412210437.7b9b13f7.ms-access.itags.org.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