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 TouchToneTommy 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: *

  • Users: dwfresh
  • Content: Threads
  • Order by date
  1. dwfresh

    Excel import/insert to existing SQL Server table

    HI, I am trying to import data from an excel spreadsheet into an existing SQL Server table. I have tried the import wizard with no luck. I then tried the BULK INSERT method as shown below: BULK INSERT mytable FROM 'C:\mypath\test1.xls' WITH (DATAFILETYPE = 'char') the error I have received...
  2. dwfresh

    SQL MAX() function question

    I know this is a pretty simple question, but I'm a rookie at SQL. I have a column named 'rowOrder' in my table. When a user enters a new item/row into the table, I want SQL to get the highest number in 'rowOrder'column, and add 1, and set that new 'rowOrder' field to that number. Can someone...
  3. dwfresh

    modify records in a DataView with index no. instead of unique ID?

    HI, I have a question. I have an XML file with calendar events. When a user clicks on a particular day in my Calendar, the events for that day are shown (using a DataView). My XML file has this structure: <Calendar> <Event> <ShortDesc>first event</ShortDesc>...
  4. dwfresh

    Rookie having problems with getting read-only .mdb to allow writing

    Hi, I am trying to make modifications to a database that is read-only and have followed all the steps to making this Acces DB a writeable database. I have gone to my particular directory where the .mdb is, (right click) Properties>Security Tab, and have made sure that the 'Write' box is clicked...
  5. dwfresh

    Why won't Netscape 6 render this ?

    HI, Something very strange is happening with my table, and the fact that Netscape won't render it correctly. I was wondering if someone could take a look at my code and tell me why everything looks great with IE 5.0(or above) , but horrible with Netscape 6.0 (or above). The weird thing is that...

Part and Inventory Search

Back
Top