Importing data from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello !

I have multiple records in an excel file and I want this data to be imported
into a table in access. One of the ways to do it would be: In Access, File ->
Get External Data -> Import...

However, the issue is, the records in excel have entries like below:
Col1 Col2 Col3 Col4
1 xxx yyy zzz
2 aaa bbb ccc
3 xxx yyy zzz
4 ppp qqq rrr
5 aaa bbb ccc

Now, while importing data into a table (say tblOne), I want only unique
records in tblOne as in after importing data, tblOne should contain:

tblOne:
Col2 Col3 Col4
xxx yyy zzz
aaa bbb ccc
ppp qqq rrr

Could someone help me with this.

Regards,
cole
 
Cole,

Don't import the spreadsheet, link it instead (File -> Get External Data
-> Link). Once yo have linked it, make a query on it (leaving out the
first column), use the Totals function (View > Totals) to group together
records where the three fields have the same value (leaving the
default Group By total function), and finally make the query and Append
one (Query > Append).

HTH,
Nikos
 
Back
Top