Steve-
You can import the data from Excel one at a time, then build a single table
that has all the column names you want to keep. Run an Append query from
each set of Excel data to your new "master" table, changing field names as
appropriate on the Append To line.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Steve Jones
Sent: Tuesday, December 04, 2012 12:19 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Newbie request
Hello to everyone on the list.
I am very new to Access but am a reasonable user of excel. The issue I have
is that I have been give a large amount of customer contact data spread over
a lot of different files. The largest file has up to 66 columns, other files
contain a differing number of columns. Files contain unique column headings
and common headings.
What I want to do is to consolidate all the files into one database with all
common columns lined up and all unique columns included. I hope this makes
sense. Can anyone help me?
Thank you
Newbie Steve
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar