Feb 26 2007, 06:27 PM
I have a daily worksheet in Excel that is formatted in the same way, all fields, always. I have to import the file in to an Access table, but when I imported it, some fields (they are formatted as number in Excel and Access) do not import and I have the record missing the three fields, (in total I have 14 fields for each record).
I tried everything, formatting in General, Text, Number, customize, but it doesn't work. The weirdest thing is that all records have the same formatting, some import without any trouble and then I got a few that do not import the specific fields, and I don't know what is wrong. I just noticed that in Excel, all the fields that are not imported has a green triangle on the top left corner. I don't know why is there but all fields not imported have that little triangle.
Does anybody have any suggestions of what can I do to make sure all fields are imported in to Access?
Feb 26 2007, 07:03 PM
whenever I import excel spreadsheets into Access I always prefer to save my spreadsheet into csv first.
this way you can choose what type of data each field will hold while you import it
another option I used to use is have a couple example records early on in the spreadsheet that will show access what kind of field you are going to be importing...
but I far prefer the first version because you actually get hands on control.
hope that helps
Feb 26 2007, 07:06 PM
I will try that..
Feb 26 2007, 07:07 PM
Good luck with your project
Feb 26 2007, 07:13 PM
I think it is part of Smart Tag in Excel. It is used to indicate to the user that Excel thinks that there is something inconsistent in the data in the cell and possible solutions. One of the common causes is that Excel think the data item should be a number but it was entered as Text value. For example:
* If you type 123 in a cel cell, Excel will store it as a Numeric value.
* If you type '123 (note the single quote at the beginning), Excel will store this as a Text value "123" but it thinks that the entry should be Numeric value so it shows the green-triangle flag.
Simply select the cell and a yellow "Information" button will appear. When you click on this button, Excel will show you the probable problem with the entry and possible fixes.
Note that Access cannot import a mixed Column of Text and Numeric values from an Excel file consistently. This is consistent with what the Excel indicator you described ...