importing data from excel

D

Database User

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?
 
D

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.
 
Top