Hi , I want to know how we skip some raws while importing a excel or text file to the table in access..? I got the below code from one site but when run it gives a syntax error msg , can anyone give me the codes for the same ? thanks in advance , RK
'SELECT T1.*.* FROM [Excel 8.0;HDR=YES;IMEX=1;Database=C:\MyFolder\MyFile.xls].[WorksheetName$A2:U65536] as T1;
'SELECT T1.*.* FROM [Excel 8.0;HDR=YES;IMEX=1;Database=C:\MyFolder\MyFile.xls].[WorksheetName$A2:U65536] as T1;