If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can import the data from excel
Hello,
I do not what's wrong. To ensure that my excel format is corret, I export the data to excel. Then on the same excel I add all the addtional data, by copy paste from other excel. When I do get external data from excel. It did not work with error message records are deleted. When I tried to import it to toher table, I see one of the reason the size of the column is 255 while the existing table in access is 50. Can anyone tell me how can I redece the size of the table?. Or what is the drawback if I change the size of the exisiting table from 50 to 255? Thanks for any help. -- H. Frank Situmorang |
#2
|
|||
|
|||
Can import the data from excel
Go ahead and change your field size to 255 characters if it helps, Frank.
There are many reasons why you may still run into trouble trying to import the spreadsheet data. Examples: - Cell contains more than 255 characters. - The number of all the characters in all the cells across the Excel row exceeds 4k characters. - A spreadsheet cells contains data of the wrong type, (e.g. "don't know" typed into a column you are trying to append to a Date/Time field.) - Your table has a foreign key field (so accepts only values that exist in a lookup or related table), and someone typed a non-matching value in the Excel cell. - Your table field has its Required property set to Yes, but the person left the cell blank in the spreadsheet. - Your table field is uniquely indexed, but the spreadsheet cell has a value that already exists in your table. - Your table field has Allow Zero Length set to No, but the spreadsheet cell contains a zero-length string. - You have a validation rule on your table (or on a cell), and the spreadsheet data does not meet the rule. - Extra columns were added to the spreadsheet that are not in your table. - All the top rows in the spreadsheet contain a number or date, but a later row contains a non-numeric/non-date value. (This problem is to do with Microsoft's spreadsheet parser, and so the row is still rejected even if you are importing into a field of type Text.) -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Frank Situmorang" wrote in message ... Hello, I do not what's wrong. To ensure that my excel format is corret, I export the data to excel. Then on the same excel I add all the addtional data, by copy paste from other excel. When I do get external data from excel. It did not work with error message records are deleted. When I tried to import it to toher table, I see one of the reason the size of the column is 255 while the existing table in access is 50. Can anyone tell me how can I redece the size of the table?. Or what is the drawback if I change the size of the exisiting table from 50 to 255? Thanks for any help. -- H. Frank Situmorang |
#3
|
|||
|
|||
Can import the data from excel
Allen,
Thanks Allen, it is the FK that I have not filled yet in the excel, it works ok now. -- H. Frank Situmorang "Allen Browne" wrote: Go ahead and change your field size to 255 characters if it helps, Frank. There are many reasons why you may still run into trouble trying to import the spreadsheet data. Examples: - Cell contains more than 255 characters. - The number of all the characters in all the cells across the Excel row exceeds 4k characters. - A spreadsheet cells contains data of the wrong type, (e.g. "don't know" typed into a column you are trying to append to a Date/Time field.) - Your table has a foreign key field (so accepts only values that exist in a lookup or related table), and someone typed a non-matching value in the Excel cell. - Your table field has its Required property set to Yes, but the person left the cell blank in the spreadsheet. - Your table field is uniquely indexed, but the spreadsheet cell has a value that already exists in your table. - Your table field has Allow Zero Length set to No, but the spreadsheet cell contains a zero-length string. - You have a validation rule on your table (or on a cell), and the spreadsheet data does not meet the rule. - Extra columns were added to the spreadsheet that are not in your table. - All the top rows in the spreadsheet contain a number or date, but a later row contains a non-numeric/non-date value. (This problem is to do with Microsoft's spreadsheet parser, and so the row is still rejected even if you are importing into a field of type Text.) -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Frank Situmorang" wrote in message ... Hello, I do not what's wrong. To ensure that my excel format is corret, I export the data to excel. Then on the same excel I add all the addtional data, by copy paste from other excel. When I do get external data from excel. It did not work with error message records are deleted. When I tried to import it to toher table, I see one of the reason the size of the column is 255 while the existing table in access is 50. Can anyone tell me how can I redece the size of the table?. Or what is the drawback if I change the size of the exisiting table from 50 to 255? Thanks for any help. -- H. Frank Situmorang |
Thread Tools | |
Display Modes | |
|
|