Results 1 to 5 of 5

Thread: Limit to Columns in MS SQL Server

  1. Jun 17th, 2004, 10:07 AM #1
    ober0330
    ober0330 is offline

    Thread Starter
    Frenzied Member ober0330's Avatar
    Join Date
    Dec 2001
    Location
    OH, USA
    Posts
    1,945

    Limit to Columns in MS SQL Server

    I'm importing a table from access which has 60 fields (yeah... don't tell me how poorly designed that is, I didn't design it.) But MS SQL Server is only grabbing about 48 of the fields. Does anyone know why this might be happening?

    edit: Even if I go in and try to build a query to import them it only shows the first 48 or so.
    Last edited by ober0330; Jun 17th, 2004 at 10:11 AM.
    format your code!! - [vbcode] [/vbcode]

    ANSWERS CAN BE FOUND HERE!!

    my personal company
    Reply With Quote Reply With Quote
  2. Jun 17th, 2004, 10:26 AM #2
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687
    When you go through the Import wizard, there will be a section where you select the table to import and where it is going, There is also a button that you can click (right in the grid there) where you can modify the table definition. Click it. Look through all the fields and make sure none are marked as "<ignore>", that the data types are OK, and that field names are OK too....

    TG
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  3. Jun 17th, 2004, 10:32 AM #3
    ober0330
    ober0330 is offline

    Thread Starter
    Frenzied Member ober0330's Avatar
    Join Date
    Dec 2001
    Location
    OH, USA
    Posts
    1,945
    I've been in there... it's not even showing the last 12 columns.

    I wonder if this is because I'm using the "trial" version of the SQL Server 7. I've been using it for months now tho and everything else seems to work.
    format your code!! - [vbcode] [/vbcode]

    ANSWERS CAN BE FOUND HERE!!

    my personal company
    Reply With Quote Reply With Quote
  4. Jun 17th, 2004, 10:34 AM #4
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687
    OOH! Ick! upgrade dude! Get SQL 2k!.... much better in this area.....

    TG
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  6. Jun 17th, 2004, 10:36 AM #5
    ober0330
    ober0330 is offline

    Thread Starter
    Frenzied Member ober0330's Avatar
    Join Date
    Dec 2001
    Location
    OH, USA
    Posts
    1,945
    Yeah... I know... I've already put in the request and I'm even using the Enterprise Manager for 2K. Everything just takes so damn long around here. It's just a development server, but it still needs some balls.
    format your code!! - [vbcode] [/vbcode]

    ANSWERS CAN BE FOUND HERE!!

    my personal company
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width