Create Table With BCP And Format File

[WayneRyan]

Hello,

I have a BCP output file and its associated format file.

Is it possible to import the data and create the NEW table?

BCP MyDB..SomeTable IN SomeTable.TXT -f SomeTable.FMT -T -SMyServer

This always gives me an error that 'MyDB..SomeTable' doesn't exist.
Can BCP create the table as part of the process?

Is it a two-step process?

Thanks,
Wayne

 

[WayneRyan]

Upon further review ...

After a little more research, I'm gathering that BCP can't create a table.

I'll have to make my own table from the Format File data.

Won't I?

Thanks
Wayne