|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
GoDaddy SQL Web Admin -- Importing CSV fileOur website is currently using an MS-ACCESS file for it's back end database. Hosted on GoDaddy. Due to performance issues, we are switching over to GoDaddy's MS-SQL Server. Our only management tool is the SQL WEB ADMIN. The only way we can see to import data into a table is through importing a csv. THIS IS FINE! We went to access, and exported the tables, using a comma delimited, text identiffier of quotes, and imported it into sql through the SQL WEB ADMIN. EXCEPT -- all the text fields physically kept the quotes. A field that previously contained: Hello kitty, how are you Now contains "Hello kitty, how are you" We have several long descriptions and text fields that contain commas and semi-colons so we definately need a text identifier. So how do we export the file from access and successfully import it into our godaddy hosted SQL server using ms SQL WEB ADMIN? Any help, guidance, comments would be greatly appreciated. Don O Palm Springs, CA presid***@palmspringsbears.org You can use DTS package to migrate data from MS ACCESS to direct SQL Server
without exporting to csv. -MB Show quote "BigDesert" <doldenb***@bigdesert.net> wrote in message news:1167600961.063396.234590@n51g2000cwc.googlegroups.com... > Okay -- Frustrated... any guideance appreciated. > > Our website is currently using an MS-ACCESS file for it's back end > database. Hosted on GoDaddy. Due to performance issues, we are > switching over to GoDaddy's MS-SQL Server. Our only management tool is > the SQL WEB ADMIN. > > The only way we can see to import data into a table is through > importing a csv. THIS IS FINE! > > We went to access, and exported the tables, using a comma delimited, > text identiffier of quotes, and imported it into sql through the SQL > WEB ADMIN. > > EXCEPT -- all the text fields physically kept the quotes. > > A field that previously contained: Hello kitty, how are you > Now contains "Hello kitty, how are you" > > We have several long descriptions and text fields that contain commas > and semi-colons so we definately need a text identifier. So how do we > export the file from access and successfully import it into our godaddy > hosted SQL server using ms SQL WEB ADMIN? > > Any help, guidance, comments would be greatly appreciated. > > Don O > Palm Springs, CA > presid***@palmspringsbears.org > I don't use sql web admin so can't really help much there.
However, if you have access to a sql client tool like Query Analyzer, you can read data from Access (via opendatasource or openrowset) and insert it directly into sqlserver table. e.g. INSERT into SqlTable SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="x:\godaddy\myAccess.mdb";User ID=Admin;Password=;')...myAccessTable INSERT into SqlTable SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', x:\godaddy\myAccess.xls.mdb';'admin';'', myAccessTable) as x -- Show quote-oj "BigDesert" <doldenb***@bigdesert.net> wrote in message news:1167600961.063396.234590@n51g2000cwc.googlegroups.com... > Okay -- Frustrated... any guideance appreciated. > > Our website is currently using an MS-ACCESS file for it's back end > database. Hosted on GoDaddy. Due to performance issues, we are > switching over to GoDaddy's MS-SQL Server. Our only management tool is > the SQL WEB ADMIN. > > The only way we can see to import data into a table is through > importing a csv. THIS IS FINE! > > We went to access, and exported the tables, using a comma delimited, > text identiffier of quotes, and imported it into sql through the SQL > WEB ADMIN. > > EXCEPT -- all the text fields physically kept the quotes. > > A field that previously contained: Hello kitty, how are you > Now contains "Hello kitty, how are you" > > We have several long descriptions and text fields that contain commas > and semi-colons so we definately need a text identifier. So how do we > export the file from access and successfully import it into our godaddy > hosted SQL server using ms SQL WEB ADMIN? > > Any help, guidance, comments would be greatly appreciated. > > Don O > Palm Springs, CA > presid***@palmspringsbears.org > Don O,
I just got off the phone with GoDaddy. They are telling me that what you are trying to do won't work on their servers~ I am trying to do the same thing. Have you gotten yours to work yet? EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com Frankly, I'm not surprised. What you folks want to do amounts to sitting
at the keyboard of their server and having at it.... Regards, Hank Arnold Angie D wrote: Show quote > Don O, > I just got off the phone with GoDaddy. They are telling me that what you are trying to do won't work on their servers~ I am trying to do the same thing. > > Have you gotten yours to work yet? > > > > EggHeadCafe.com - .NET Developer Portal of Choice > http://www.eggheadcafe.com  |
|||||||||||||||||||||||
Other interesting topics