March 2, 2015 at 1:28 pm
I have a 14899 record CSV file exported from GOOGLE Admin console. I linked that into my ACCESS 2007-10 database and discovered that only 14717 of the records are showing in the access side of the linked table. However... when i actually IMPORT the CSV into the local table in MSAccess all 14899 of the records make it and are visible. Any thoughts on how I'm loosing records when doing the linkiing to the CSV would be appreciated.
March 2, 2015 at 3:09 pm
Chances are you have some data in the missing records that don't fit within the schema that Access associates with each field - it only scans the first hundred or so rows to decide what kind of data type to assume. For example, you may have some character data in a field that Access thinks is numeric, or you may have a date field outside the range that is legal in Excel. On the other hand, if you import it into an existing table, you define the field types, and that allows it to import. I've done a good deal of this kind of thing, in some cases with multi-million rows, and the import will find and flag data that is invalid, where linking doesn't give you as much info.
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply