How to work with many tables all have the same fields?

  • Thread starter Thread starter M.A.Halim
  • Start date Start date
M

M.A.Halim

I'm collecting data from several locations by email using excel Sheets, all
lcations are using the same format, I have to collect all these sheets and
make one big table in Access mdb. If I link these sheets to the data base I
will end up by having many tables same data and same field names. the size of
these sheets quite big.
how to solve this issue? All I need is to combine them in one Access table
mdb.
Thanks
 
Create a link to each sheet or link one sheet at a time. After you link the
first sheet create a query, add this sheet to the query and pull in all the
fields. Add a field "Example: "Source 1". Make this a "Make Table Query"
and run it creating your new data table.

For each subsequent sheet you link create an append query to add the new
data to your table changing the Example field to "Example:Source 2" etc.
 
Learn to cross post by adding the name of each newsgroup to your
post. That way, an answer in one newsgroup propogates to all of the
other newsgroups. What you have done is "multipost" - posting the
same issue into more than one newsgroup. Your question has already
been answered in another newsgroup...

HTH
 
O.K Larry
I have opened the advanced options,I found a text box what i fill in it. I
don't know the other groups. and I wanna deal with this group only.
--
M.A.Halim
(e-mail address removed)


Larry Daugherty said:
Learn to cross post by adding the name of each newsgroup to your
post. That way, an answer in one newsgroup propogates to all of the
other newsgroups. What you have done is "multipost" - posting the
same issue into more than one newsgroup. Your question has already
been answered in another newsgroup...

HTH
Click to expand...
 
Back
Top