Access Databases and AccessDataSource Control

Re: importing data from excel to ms-access

v.vivek — Fri, 03 Jul 2009 09:35:23 GMT

charecter present in one of the column in your excel sheet is more than the size of access column.i thik colums are like address,description etc

Re: importing data from excel to ms-access

v.vivek — Fri, 03 Jul 2009 09:29:06 GMT

size of value in one of the excel column is greater than size of corresponding column of ms access. this may be your address feild.

Re: importing data from excel to ms-access

hans_v — Wed, 01 Jul 2009 16:42:54 GMT

Well, the error explains it all. One (or more) of the fields in the excel file are longer as the maxfieldlength of the corresponding field in the database. The max length of a text field in access is 255. If the excel file contains fields longer than 255, use the memo type for that field

importing data from excel to ms-access

sashakt2 — Wed, 01 Jul 2009 15:27:29 GMT

I am trying to insert data in 21 columns of ms-excel into ms-access with the help of ADO.NET code. When I insert lesser data in ms-access, its working fine. Problem comes when all data needs to be inserted. An insert into statement is used as a query.

I am getting the following error:

System.Data.OleDb.OleDbException: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.

Plz help!