This way may be easier:
- in Excel, select both columns, copy & paste special (transpose), so the first row becomes column header and the 2nd row is data
- import to your Access db
Jliu6
Last Activity: Sep 15 '06, 05:41 PM
Joined: Aug 30 '06
Location:
-
load data from XML files to the existing Access tables HELP
I have 4 related tables in the Access database and data was sent me in XML files. I need to load data from XML files to my existing Access tables not just import XML files to the database.
Any suggestions/comments are greatly appreciated!
No activity results to display
Leave a comment: