Quick question - Exporting Excel Files

L

luis.a.roman

I'm trying to import an excel spreadsheet to an access table but when
the cells are merge the import create two records on the table. Is
there any way that I can tell access that the cells are merged and
transport the file as on record.

Guidance will be appreciated.

Luis
 
J

John Nurick

Hi Luis,

There's no easy way of doing this. The best thing to do is to un-merge all
the cells in Excel, so each record is in a single row.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing from Excel to a droplist field 1
How can I import an unstandard Excel worksheet into Access 2007? 3
Export to Excel 3
Data consolidation 1
Import to many to many table 7
Importing Excel Data - Error Message 3
Export to Excel more than 900,000 records 2

Top