Search results for query: *

I figured out part of my problem. The excel file had an empty USerID field because I thought the SQL table would insert the UserID automatically. I don't really have an UserID field or AddedDate field in the excel file. In my website, I use the follwing stored proc to insert each new record...

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...

perfect, thanks Paladine !!

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...

exactly what i was thinking, thanks for the advice paul!!

Thanks Paul ! I understand... so I have one more silly question. SO let's say I create another element <EventID> in my XML file. how would I go about generating a unique ID# to fill this element each time I add a new event? I was thinking that I could do something like start with 1 and just...

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>...

It worked, thanks Little Smudge!! one of those t hings you overlook and you can't believe you didn't think of yourself. thanks a ton. Thanks to Ken too, that is helpfull info in the future!

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...

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...