Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002

    Unanswered: import notepad file into access

    Can we import file in notepad to MS Access? How?

  2. #2
    Join Date
    Feb 2002
    Sure you can, or you can even link to it.

    Depending on which version you are using, click on File, Get External Data, then Import or Link Tables.

    In the bottom of the dialog box, the default Files of type is Microsoft Access, so change it to Text Files and select your file.

  3. #3
    Join Date
    Sep 2001
    Chicago, Illinois, USA
    If you want to do the import in code, look at the TransferText method in the Access help area.

    Both the method mentioned by TJoy, and the TransferText method (which is just the command version of what TJoy recommended), are less than ideal if you are not wanting the text to be imported in to a table.

    If you want to simply read the information and import it in to a variable, then you are going to have to use the following:

    Dim FileString as string
    Open FullyQualifiedPathAndName For Input As #1
    Do Until Err<>0
         FileString=FileString  & Input(1,1)
    Close #1

Posting Permissions

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