[Q] Question on MS Access

Results 1 to 2 of 2

Thread: [Q] Question on MS Access

  1. #1
    Ed Lee Guest

    Default [Q] Question on MS Access

    is there any way to import data from text file to MS Access?<BR><BR>i have a list of names that i need to enter to Access DB in text file, but i have no idea how I can put these into MS Access.<BR><BR>How can I do this?<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: [Q] Question on MS Access

    open Excel spreadsheet, in the menu click "Data" then "Import text files" save it as tab delimited, make sure all columns in the database table are present in the spreadsheet, then just copy the whole file open Access and "Edit" then "Paste Append", this should work.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts