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 |
|
LostShrew
Starting Member
5 Posts |
 Posted - 2010-04-14 : 09:28:56
|
| I am looking to move over some data held in a .csv.The system is an access local front end sitting on a sql server. Now i can use VB to transfer this data into the database and triggers to move the data around the tables.We are looking to move everything server side and have a web based front end. so this will be reduntant and as such are looking to write more of the code in T-sql, or produce something in SSIS.My questions are:-What would be the best way of moving this data?Can a VBA button/code trigger SSIS?Can i pick up it up in a recordset and send it straight to a sproc to deal with? |
|
|
|
|
|
Import excel data into SQL server 2005