Results 1 to 3 of 3
  1. #1
    Souperbc is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2011
    Posts
    2

    Help with Importing


    I'm a student in school and am having trouble with access. I'm having to create an import button that will import a text file from a non-local machine. I have never really used Visual Basic very much. I have found a few pieces of code that I have tried, but did not work. I'm recently trying a "DoCmd.TransferText" Command but it is not compiling and I am having trouble understanding it.

    Thank you in advance.

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    it's not compiling?? that doesn't makes sense, bud. that's a word you use when you're testing for code bugs or prepping a distribution project. if you're doing that to test the validity of code, I would understand what you mean.

    if it is non-local, could you use that same transfer text method and use the good 'ol "\\" qualifier to tell VBA that the text file is located on a network machine??

  3. #3
    Souperbc is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2011
    Posts
    2
    Thank you Adam for answering.

    I am mostly just having trouble trying to implement the "DoCmd.TransferText" Command. If I could just get some explanations on how to implement this command that would really help out. An example would help also.

    I have also read up a little bit about a "schema.ini" file that needs to be created. Some help on that would be much appreciated also.

    Thank you.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Max out after importing only 188 fields
    By weston in forum Import/Export Data
    Replies: 2
    Last Post: 03-06-2011, 12:07 AM
  2. Importing Spreadsheet
    By derfalpha in forum Access
    Replies: 1
    Last Post: 01-04-2011, 10:47 AM
  3. Importing .txt data
    By Redder Lurtz in forum Import/Export Data
    Replies: 4
    Last Post: 11-18-2010, 10:23 AM
  4. Need help in importing table
    By sdondeti in forum Access
    Replies: 6
    Last Post: 11-16-2009, 09:38 AM
  5. Importing Txt file via Vb
    By jquickuk in forum Import/Export Data
    Replies: 1
    Last Post: 04-01-2009, 08:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums