Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. elallred

    exporting a table to .txt format created from SQL view

    I frequently convert MSACCESS tables (ACCESS 2000) to ASCII delimited text and am almost always successful. However, I have imported a VIEW from an MSSQL envinroment to ACCESS and am attempting to to convert that table to ASCII delimited and I keep getting the message "Illegal...
  2. elallred

    reordering column names in table easily

    We had an outside "consultant" who created a table with over 500 columns. These column names seem to be arranged randomly --there is no discernable order to them. I would like to reorder the names in alphabetical order. Is there an easy way to do this?
  3. elallred

    Cannot delete or change duplicate rows in table

    I have a sql server table (PAF6) with about 10 duplicate rows out of 940. (This table has 540 columns -- although I do not think this relevant). I can delete or modify the data in every row except these 10. I get the error message "key column information is insufficient or incorrect. Too...
  4. elallred

    Import or link 540 field SQL table into ACCESS

    Since ACCESS has a limit of 255 fields per table, I find when I find that whether I link or import the table Paf6 which resides on our SQL server, I get only the first 255 fields out of the 540 fields it contains. Is there a way in which I can get ACCESS to import or link all 540 fields? E. Allred

Part and Inventory Search

Back
Top