Results 1 to 4 of 4

Import mulitple text files into Access 2010/each a separate table

  1. #1
    burnettec is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2013
    Posts
    5

    Import mulitple text files into Access 2010/each a separate table

    I searched this forum and found vba code to import multiple text files into ONE Access table, but I need mine to be kept separate. Also, I didn't understand the copyrighted code for that posted procedure. Any suggestions? Thank you.

  2. #2
    JoeM is offline Experienced Access User
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    1,655
    The standard is to usually import each file into a separate table. Depending on how you are importing it, you would just have separate import statements for each table.
    What exactly are you having trouble with?
    I think we need more details. Also, if you have a link that you found that you are trying to use, can you include it here so we can see what you are looking at?
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

  3. #3
    burnettec is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2013
    Posts
    5
    Well, I guess I was just being lazy. I have 102 files I need to import into 2 separate databases, keeping each file a separate table. I only have to do it once, not a repeated task monthly or anything. Over lunchtime I already imported the first 51 files into the first database. It was a pain doing it one at a time. Guess I"ll just take another hour to import the others. Anyway, I figured this situation would come up again and thought it would be nice to write VBA code that would have the user choose a folder containing all the same file types (txt, or csv, or xls) and then loop through each file, importing it into it's own table in one database. The code I found for importing files into one table in a database is in the following post: http://www.accessforums.net/import-e...ally-2030.html Thanks for your reply.

  4. #4
    JoeM is offline Experienced Access User
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    1,655
    You can definitely do it, but you might need to come up with some logic as to what you want to name all these tables.
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

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

Similar Threads

  1. Replies: 7
    Last Post: 11-20-2012, 03:08 PM
  2. Replies: 19
    Last Post: 10-08-2012, 06:47 AM
  3. Replies: 1
    Last Post: 06-27-2012, 06:39 AM
  4. Import Text Files without access
    By 95DSM in forum Import/Export Data
    Replies: 1
    Last Post: 09-10-2010, 03:36 PM
  5. Field returns error when I import Text Files to Access
    By geng in forum Import/Export Data
    Replies: 3
    Last Post: 06-01-2010, 01:20 PM

Posting Permissions

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