Search results

Hi All I import data from exel 2000 into access 2000 how can I remove duplicate and unwanted data (ie Blank rows) I recieve my daily work via an e-mailed exel spreadsheat which is then transposed before being exported to access. I have allowed for upto 12 customers per day in my transpose...

Tony I have used your code to open an Exel worksheet Private Sub Command16_Click() On Error GoTo Err_Command16_Click 'Dimension the Variables Dim xlApp As Excel.Application Dim xlWkbk As Excel.Workbook Dim xlSht As Excel.Worksheet 'Set the application Set xlApp = New Excel.Application 'Make...