[AccessD] Not all values paste from Excel to Access

Benson, William (GE Global Research, consultant) Benson at ge.com
Sun Mar 18 15:15:44 CDT 2012


I want to say from the start, I worked around this problem by changing my Excel fields to text number format, but here goes, I still think this is a bug in Access.

I set up a table called Equipment Model with 3 fields. The first was an autonumber, the next two were text. In Excel I had a table like this:

Blank Field	Equipment Code		Equipment Model
		CIGS				85
		CIGS				90
		CIGS				130
		CIGS				135
		CIGS				140
		CIGS				145
		CIGS				150
		CIGS				155
		CIGS				160
		Controller			SunIQ
		Inverter			700kW
		Inverter			714.2kW
		Inverter			1MW
		Skid (STP)			Transformer

I copied the three columns from Excel and pasted into the Access table. Only the items up to and including the Equipment Model = 160 record got pasted.

If it was a numerical field, I could understand it, but it is a text field. And it is a really small number of records, so I can hardly picture Access getting confused.

So I went back to Excel and checked NumberFormat - it was General. (At this point I am thinking "So what, there are some text entries and besides, the field is set up as text in Access").

Anyway, I changed number format in Excel to Text, and retried. They all pasted that time.

I put this down as learning to deal with Microsoft's craziness, but I am happy for someone to point out any improper expectation on my part as a user/developer!





More information about the AccessD mailing list