Results 1 to 6 of 6
  1. #1
    pwhite9279 is offline Novice
    Windows 10 Office 365
    Join Date
    Apr 2021
    Posts
    3

    ODBC related - need to populate multiple xml files into an access dbase

    I'm actually using access for the first time in about 11 years. I had to get help with setting ODBC connection from a particular software to access. My mentor had me run my cmd to do this on cmd line, but i'm not sure why that's necessary. I run on the cmd line siw2odbc32 [filename], i think it's erroring out and what i see in my siw-access.mdb is from last night's population. Can someone look at my files and help?



    Thanks in advance.

    Pam White, Consultant
    White Consulting

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,834
    in access, did you click the external data button, excel button, then select your xl file?
    link it in as a table then you can import data.

  3. #3
    pwhite9279 is offline Novice
    Windows 10 Office 365
    Join Date
    Apr 2021
    Posts
    3

    multiple XML files

    Quote Originally Posted by ranman256 View Post
    in access, did you click the external data button, excel button, then select your xl file?
    link it in as a table then you can import data.
    No, these are XML files, not excel files

  4. #4
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    841
    there is also an xml import wizard on the ribbon
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  5. #5
    pwhite9279 is offline Novice
    Windows 10 Office 365
    Join Date
    Apr 2021
    Posts
    3
    I tried the xml import but so many of the columns come over with table as the value and you have to drill down to the data

  6. #6
    NoellaG's Avatar
    NoellaG is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    734
    I remember that importing XML in Access is a pain in the ass. In those days (I'm talking now more then 10 years ago, so things might have improved since then) we ended up importinging the XML into Excel, and then importing the excel into access.

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

Similar Threads

  1. Replies: 1
    Last Post: 11-29-2013, 05:18 PM
  2. Replies: 4
    Last Post: 06-14-2011, 07:19 PM
  3. Replies: 4
    Last Post: 01-20-2011, 10:05 PM
  4. importing Dbase files
    By dzawicki in forum Import/Export Data
    Replies: 2
    Last Post: 01-14-2010, 05:43 PM
  5. ODBC related struggles
    By gray8110 in forum Access
    Replies: 0
    Last Post: 12-08-2008, 02:31 AM

Tags for this Thread

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 - Senior Forums