GoDaddy SQL Web Admin -- Importing CSV file

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
president@.palmspringsbears.org
You can use DTS package to migrate data from MS ACCESS to direct SQL Server
without exporting to csv.
-MB
"BigDesert" <doldenburg@.bigdesert.net> wrote in message
news:1167600961.063396.234590@.n51g2000cwc.googlegr oups.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
> president@.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
-oj
"BigDesert" <doldenburg@.bigdesert.net> wrote in message
news:1167600961.063396.234590@.n51g2000cwc.googlegr oups.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
> president@.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:
> 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