ScottMattes
Member³
I don't know if I can do this justice, but here goes.
I was trying to build local tables with data from another system. I logged on the source DB and selected the rows I wanted and saved them to a CSV file. I did this for 2 tables on the source.
I then logged off and logged onto the target system. The tables already existed and were empty. I imported the first file with no problems. The second file refused to read and parse the CSV file and I had to specify the number of columns by hand. I then had to manually specify which table field went with what CSV field. The import failed though and I forget the error msg, sorry about that. I tried a few different things that didn't work, except to show me that it wasn't going to load like that. I then saved the insert statements to a file and looked at it. It lookked like the phone number fields were in Euro format ( '.' instead of '-'). Granted, they shouldn't have made the phone number fields numbers, but once I removed the '.'s the load worked just fine.
I was trying to build local tables with data from another system. I logged on the source DB and selected the rows I wanted and saved them to a CSV file. I did this for 2 tables on the source.
I then logged off and logged onto the target system. The tables already existed and were empty. I imported the first file with no problems. The second file refused to read and parse the CSV file and I had to specify the number of columns by hand. I then had to manually specify which table field went with what CSV field. The import failed though and I forget the error msg, sorry about that. I tried a few different things that didn't work, except to show me that it wasn't going to load like that. I then saved the insert statements to a file and looked at it. It lookked like the phone number fields were in Euro format ( '.' instead of '-'). Granted, they shouldn't have made the phone number fields numbers, but once I removed the '.'s the load worked just fine.
