Import from Excel with Paragraphs

[Willem]

I have got an excel sheet which looks like this (boogey data):
Honda
Accord
datarow, datarow, datarow, datarow
datarow, datarow, datarow, datarow
Civic
datarow, datarow, datarow, datarow
datarow, datarow, datarow, datarow
Mazda
121
datarow, datarow, datarow, datarow
datarow, datarow, datarow, datarow
datarow, datarow, datarow, datarow
datarow, datarow, datarow, datarow
323
datarow, datarow, datarow, datarow
datarow, datarow, datarow, datarow

etc.
Is there any way I can import this in access?

 

[Douglas J. Steele]

Not directly.

My advice would be to use Automation to read the data from the spreadsheet,
and write it to the Access table(s) manually. I talk about automating Excel
in my July, 2005 "Access Answers" column in Pinnacle Publication's "Smart
Access". You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[Willem]

Thanks, I'll have a look at it.