Search results

Thank you for your answers, but I think the error does not come from there. I'll state clear so maybe anybody can help: SQL query: INSERT INTO Albums(Album, Year2, Comment) SELECT DISTINCT Album, Year2, Comment FROM _Import Albums and _Import tables are exactly the same, except that Albums...

sorry i expressed myself in a bad way, both fields (comment and comentario) are memo fields, in fact table structure is exactly the same, just a copy/paste one from the other.

Hi, When I try to execute a SQL query in access I get the next error (sorry translated from spanish) runtime error 3163: The field is too little to accept the amount of data you are trying to add. Try to add less data. The SQL is: INSERT INTO _AlbumsTmp (Album, Anyo, Comentario)...

Hi neileg, The first solution works! I just changed rows order on the excel file and it works. Thanks!

Hi, I'm using Access 2002 to import data from a CSV/Excel file, an it does ok, except a memo field. Although I don't know which is the max number of characters an excel cell can store, it seems the entire memo field is stored in spreadsheet, but when importing into access with the wizard, the...