Reading .xls file using VBA code

[stalk]

How can I read the .xls file line by line and save to a table?

File Name	C:\temp\trpt.mdm
Experiment Run End Time	2016-12-20 01:34:37 AM EST
Instrument Type	trial
Passive Reference
Dwell	Sample Name	Target Name	Reporter	MT	MTMean
B1	FTC	PebA	FOR	Undetermined
B2	S1	PebA	FOR	29.10263	29.10263
B3	S2	PebA	FOR	27.39697	27.39697
B4	S4	PebA	FOR	36.99042	36.99042
B5	S6	PebA	FOR	31.15202	31.15202
B6	S7	PebA	FOR	28.16815	28.16815
B7	MOCK	PebA	FOR	Undetermined
B8	HTC	PebA	FOR	21.80263	21.80263

[ranman256]

you DONT read it line by line,
you import it all at once with
docmd.TRANSFERSPREADSHEET
or
link the excel file as a table then run an append query to import all records.

[aytee111]

Or save it as a csv/text file, then you can read it line by line.

[ranman256]

reading line by line is 1000 times slower.