January 13, 2006 at 1:52 pm
Hi, I'm trying to import some data from a flat file. But I don't want to import all the columns, only a few. And, I want to import it into a specific table that already exists -- I want to append rows to that table.
A couple of things:
(1) I can't figure out how to tell it I only want 3 columns out of 20+. I tried deleting all but the 3 I want to import in the "advanced" tab, but then it thought I wanted the first 3 columns in the file.
(2) I can't seem to select the table I want to import into. The wizard decided it was going to create a new table for me, because (I guess) the file had a different name from the table I wanted to import into. And it didn't give me the choice of picking a table. It was going to create a new table whether I liked it or not.
Is there any way to use the wizard to accomplish my goals here? Or, alternatively, can I forgo the wizard altogether -- is there a "non-wizard" mode?
Thanks,
Cynthia
January 13, 2006 at 2:26 pm
On the 'Select Source Tables and Views' screen in the wizard, select the Transform .... button. Then go to the Transformations tab and select the 'Transform information as it is copied to the destination' radio button. You can then edit the VB script to only grab the colulmns that you want.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply