Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import entire folder of CVS files
Message
 
 
To
12/07/2013 08:50:54
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Environment versions
SQL Server:
SQL Server 6.5 and older
Application:
Web
Miscellaneous
Thread ID:
01578298
Message ID:
01578301
Views:
51
>>>How is possible to import a folder of CVS files to create a single table for each CVS file. They have unique file names.
>>
>>ADIR() + 'IMPORT FROM ... CSV'
>
>Ok, But I guess should mentioned that I am importing into SQL Server 2008 R2.

I should have look at the forum more closely :)

Google 'sql server import CSV files', for example

http://stackoverflow.com/questions/16076309/import-multiple-csv-files-to-sql-server-from-a-folder
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform