Results 1 to 2 of 2
  1. #1
    herbc0704 is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    16

    Importing XML to Access


    I receive daily files in XML. I need to imprt these to access. However, during the import I realized the files that are being imported don't have a date field. Is there a way to import the files and some how have a date filed added during the import into the new data base table?

  2. #2
    blue4512 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    26
    create a field for the Date (data type: date/time) with the default value be date(), which will fill the the date field with the date of the import.

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

Similar Threads

  1. Replies: 1
    Last Post: 07-31-2010, 08:04 AM
  2. Importing Excel into Access
    By Nel1975 in forum Access
    Replies: 3
    Last Post: 12-30-2009, 10:21 AM
  3. iMPORTING DATA FROM EXCEL TO ACCESS
    By Rameez in forum Import/Export Data
    Replies: 7
    Last Post: 06-16-2009, 12:05 PM
  4. Importing file into Access
    By jquickuk in forum Import/Export Data
    Replies: 1
    Last Post: 03-23-2009, 09:18 PM
  5. Importing Xls and CSV files into MS Access
    By Jeff in forum Import/Export Data
    Replies: 1
    Last Post: 02-17-2009, 11:56 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
  •  
Other Forums: Microsoft Office Forums