DATA extract from MS access

[pavanranjan]

Dear Sir

I have The Below Data:-

<table border="0" cellpadding="0" cellspacing="0" width="214"><col style="width: 48pt;" width="64" span="2"> <col style="width: 17pt;" width="22"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; width: 48pt;" width="64" height="17">Inv No</td> <td class="xl22" style="border-left: medium none; width: 48pt;" width="64">SKU</td> <td class="xl22" style="border-left: medium none; width: 17pt;" width="22">Ltr</td> <td class="xl22" style="border-left: medium none; width: 48pt;" width="64">Per Unit</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; border-top: medium none;" height="17">IG121654</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">FR123</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">20</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; border-top: medium none;" height="17">IG121655</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">FR124</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">20</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">31</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; border-top: medium none;" height="17">IG121656</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">FR125</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">20</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">50</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; border-top: medium none;" height="17">IG121657</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">FR126</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">20</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">69</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; border-top: medium none;" height="17">IG121658</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">FR127</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">20</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">88</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; border-top: medium none;" height="17">IG121659</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">FR128</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">20</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">107</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; border-top: medium none;" height="17">IG121660</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">FR129</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">20</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">126</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; border-top: medium none;" height="17">IG121661</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">FR130</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">20</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">145</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; border-top: medium none;" height="17">IG121662</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">FR131</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">20</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">164</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; border-top: medium none;" height="17">IG121663</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">FR132</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">20</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">183</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; border-top: medium none;" height="17">IG121664</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">FR133</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">20</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">202</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; border-top: medium none;" height="17">IG121665</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">FR134</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">20</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">221</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; border-top: medium none;" height="17">IG121666</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">FR135</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">20</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">240</td> </tr> </tbody></table>

I need to check these Unique filed of data from master excel sheet ,
is there any way in MS access / Macros to extract the data in one shot .Kindly reply

 

[Rasm]

You want to import xl data into Access ???

Not sure of your question

 

[pavanranjan]

You want to import xl data into Access ???

Not sure of your question

Dear Sir

I have to check the inv no,SKU code,Ltr,Per Unit Amount for perticular Invoices from a large database of the same .my problem is that database is near about 150Mb of Excel file .So when i filter the same ,File hangs usually.
Now i want that if there is any idea in Ms access to exctract the data of unique field in one shot.

Pls Help