import the first record of a repeated number

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

Guest

Access 2000 - MS WinXP Pro 2002

I am tryint to import data from excel, I have a column with a series of
numbers that repeat but I only want to use the first number with out the
repeats.

There is a number of other columns with either descriptive data that some
times repeats through out the spread sheet that I also need with the number
data.
 
hi,
If you are using the import wizard, the wizard will import
all date that it finds.
in access, you could run an xl macro that copies the data,
runs a delete doubles sequence then link to that data.
Function Open_xlfileName()
Dim xlApp As Variant
Dim xlBook As Variant
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Open _
("C:\data\excel\TrainLoading.xlt")
xlApp.Run "MyXLMacro"
'xlApp.Application.Visible = True
xlBook.Close (False)
xlApp.Quit
Set xlApp = Nothing
Set xlBook = Nothing
End Function
 
Back
Top