Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
castillolj
Starting Member
1 Post |
 Posted - 2010-07-09 : 13:31:11
|
| Hi, I use a OpenRowset Query to create a table in SQL Server from .txt file. The command don't show errors, but the table does not have all the columns. It only appears 255. The original file has 623 columns.The example is:SELECT * INTO TB_TEMPORAL FROM openrowset ('MSDASQL','Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\MG\;','SELECT * FROM XXX.txt')I need to use something similar because the columns may varies in the .txt.Thanks for your help. |
|
|
|
|
|
OpenRowset don't show all columns