Help with import data from a text file via sql into a table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ozchadl
    New Member
    • Apr 2010
    • 26

    #1

    Help with import data from a text file via sql into a table

    I wish to import some data I have in some (tab delited) files that I would like to import into certain tables in my access database.
    I would like to import them using SQL only.
    I know there are other ways to import the data, but I want to be able to do this with sql.

    I belive it may be an insert into statement.

    Thanks for you help.
  • Darren McDonald
    New Member
    • Aug 2010
    • 7

    #2
    This may give you some ideas;-
    Attached Files

    Comment

    Working...