Dunno where to post this....

[Tanner65]

Preface: I don't know where to post this since I'm using a VBA executed SQL command or if this is a table issue.

I'm trying to import a .csv file into a "master" table of several .csv files. I've figured out how to link them and import them even though they have different field names, but the problem I'm running into is with serial numbers.

Some serial numbers are entirely numbers, while others are alphanumeric. When the field is set to numbers all of the parts (a different field) show up, but not all of the serial numbers are imported. When the field is set to text some of the parts are dropped, along with their associated serial numbers and then some of the serial numbers show up as scientific notation.

Any ideas on how to solve this problem?

 

[Tanner65]

After some looking around, I need to have this thread moved to the Tables forum.

The reason it was dropping some parts is that the parts serial numbers are "05130520101121" and "05130520101357" respectively. After changing the field to indexed (duplicates ok), the serial numbers show up as "5130520000000" for both, thus it kicked out one of them since they were "duplicates." Unfortunately, even the serial numbers "1596010505035090" and "1596010505035050" did a similar thing. They were inserted as "1.59601E+15."

It also didn't transfer over the serial number "Y1A2JTJ929" or any other alphanumeric serial numbers although the field property is set to Text.

Any ideas on how to fix these problems? Is there a way to have it transfer both over correctly without changing the numbers?

 

[Tanner65]

After further research, I discovered my data had been "corrupted", when I had opened the csv files in Excel.

Also, after those corrections were made, I needed to have a spec template for when I imported that one csv file.

Any ideas on why I wouldn't need a template for any others?