Printable View
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. :mad:
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'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. :cry: I've been using it for months now tho and everything else seems to work.
OOH! Ick! upgrade dude! Get SQL 2k!.... much better in this area.....
TG
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. :rolleyes: It's just a development server, but it still needs some balls.