[AccessD] How to Add a New Microsoft SQL Server Table using ODBC and Access 2007

Paul Hartland paul.hartland at googlemail.com
Thu Mar 20 22:52:00 CDT 2014


Brad,

In that case try something like below:

    yourdbconn.ExecuteSQL.("CREATE TABLE tablename (field1 nvarchar(50)" ",
field2 int)");

and so on for your fields.

Paul


On 20 March 2014 21:45, Brad Marks <BradM at blackforestltd.com> wrote:

> Paul,
>
> I do not have access to GoDaddy's control panel.
>
> I only have access to the GoDaddy database via ODBC (using Access 2007).
>
> Thanks,
> Brad
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Hartland
> Sent: Thursday, March 20, 2014 4:44 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] How to Add a New Microsoft SQL Server Table using
> ODBC and Access 2007
>
> Might be a silly question as you may not have the access, but can you
> not just log onto GoDaddy's control panel, got to the database and add
> it ?
>
> Paul
>
>
> On 20 March 2014 21:20, Brad Marks <BradM at blackforestltd.com> wrote:
>
> > All,
> >
> > For several years, I have worked with a Microsoft SQL Server database
> > that is tied to our website (Hosted by GoDaddy).  A web guru in
> > another city has designed the website, database, etc.  My role has
> > been to simply pull data from this database.
> >
> > Now, as part of some "Back Office streamlining", we would like to add
> > one new table to this existing database.
> >
> > I have never added a new table to Microsoft SQL Server from Access
> 2007.
> > What is the best way to do this?
> >
> > I have worked with IBM's DB2 DDL in a prior life but not with SQL
> > Server DDL.
> >
> > Thanks,
> > Brad
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
>
> --
> Paul Hartland
> paul.hartland at googlemail.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> This message was scanned by ESVA and is believed to be clean.
> Click here to report this message as spam.
> http://h0stname/cgi-bin/learn-msg.cgi?id=BB22828FFF.DFB10
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com


More information about the AccessD mailing list