skipping raws while importing (1 Viewer)

rkishan1

New member
Local time
Today, 01:56
Joined
Mar 15, 2012
Messages
2
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;
 

Users who are viewing this thread

Top Bottom