SELECT INTO - Importing a text file into a new table

• patelxx

  SSC Eights!

  Points: 853

  More actions

  June 6, 2015 at 2:58 am

  #398554

  Hi,

  Please can someone guide me on how to import a text file with a list of NI numbers into a new table with a column to list all the NI numbers? I think I use the Select INTO clause, but not sure how to do this?

  Thank you

• Phil Parkin

  SSC Guru

  Points: 246993

  More actions

  June 6, 2015 at 3:08 am

  #1803508

  You could try the import wizard.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel