Blank records appearing after import from excel

's Computer Specifications

I am importing from excel to access (both 2007)- when i go through the import
steps, just what i want to import is there. When I look in access, several
blank records are added at the end. What can I do to prevent this?

's Computer Specifications

These are probably rows in Excel that have either data or formatting applied.
Delete them in Excel or delete them from the Access table after imported.

--
Duane Hookom
Microsoft Access MVP

"melhale" wrote:

> I am importing from excel to access (both 2007)- when i go through the import
> steps, just what i want to import is there. When I look in access, several
> blank records are added at the end. What can I do to prevent this?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How keep blank non-existent records from appearing in sub-report?	Arrowhead	Microsoft Access Reports	1	29th Mar 2009 03:54 AM
Extra blank records in Access which are blank records in Excel Fil	kza40381	Microsoft Access External Data	1	7th Jan 2009 09:23 PM
blank records in an XML data import into access 2003	Jim Quaglio	Microsoft Access	2	16th Nov 2007 02:34 PM
can not import records with blank fields	=?Utf-8?B?U2FuZHJhUA==?=	Microsoft Access External Data	1	18th Oct 2004 10:13 PM
can't import fields with blank records	=?Utf-8?B?U2FuZHJhUA==?=	Microsoft Access External Data	0	18th Oct 2004 02:39 PM