General information
Category:
Coding, syntax & commands
>Joseph,
>
>Can you do a REPLACE ALL " with ' on your entire table
>followed by a REPLACE ALL ''' with ''" on your entire table
>prior to doing the APPEND FROM?
>
>I think the triple double quotes are what is messing things up for you.
>
>Computers in SD? I thought you were still fighting indians. Just kiddin.
>I was born in Sioux Falls and raised in Huron. Been a Floridian for 30+ years. Still got lots of family up there.
>
>MOO!
Unfortunately this file is coming from an outside source so I do not have access to the original table.
I can get it to work using the Import wizard, but it is too slow as each table has almost 1.5 million records and I have 30 text files that I need to do this to.
PS I was born and raised around the Sioux Falls area, Larchwood, IA to be exact.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only