Hello, sorry to sound so uninformed about this, but really, I am...
I need to do regular text imports, into a table, but I dont want to have to set the columns and spaces in the text import wizard each time, because its a rather long record (300+ spaces, with LOTS of columns).
So I was wondering what was involved in doing regular (daily) text imports, when the data im importing is always in the same format...is there some way to have a "saved" text import layout?
Im using fixed length text files.
Be happy to provide more information if needed, my appologies if this is the wrong forum, please direct me to the right one?
Thank you in advance!
I need to do regular text imports, into a table, but I dont want to have to set the columns and spaces in the text import wizard each time, because its a rather long record (300+ spaces, with LOTS of columns).
So I was wondering what was involved in doing regular (daily) text imports, when the data im importing is always in the same format...is there some way to have a "saved" text import layout?
Im using fixed length text files.
Be happy to provide more information if needed, my appologies if this is the wrong forum, please direct me to the right one?
Thank you in advance!