importing data from excel

[Guest]

I want to import data from Excel into Access but each record is on 2 lines in
the excel sheet so if i import 100 records from excel how can i tell access
to look at each 2 lines as one record - is there any way?

 

[Douglas J Steele]

There's no built-in way.

You could either import everything into a temporary table, then write
queries in Access to "stitch" the rows back together, or you could use Excel
Automation.