Macro Help: To copy the CSV file into Excel sheet

[simi]

Hi All,


I have CSV file generated on one location. I need a macro to copy the date from the CSV file and paste in my workbook in sheet1.

For Example
-------------

CSV file location is
C:\temp\test.csv

data is available in sheet1

if i run a macro from my excel sheet, it should copy the data from CSV file sheet1 and paste it in my workbook sheet 'Sample'


Thanks in Advance

[patel45]

attach a sample of csv file or paste here some lines

[simi]

The sample data in CSV have
ID Product
1 a
2 b
3 3