Insert date/time records from access into a sql database.
Posted on 2008-10-29
I have an application that pulls dates and numbers from an access database. I need that database to be in SQL, aso I created a new table - In access the values where formatted as date/time. When I created it the new table in SQL, I formated it as small date time.
I need to insert all of the records from access into the database. When I pull up the ScriptTable as-->INSERT to code, it gives me this...
INSERT INTO [clients].[dbo].[Calculator]
Where and how (the proper syntax) would I enter these to rows from the access database...
PayCalendar / K-CutOff / PayPeriodsRemaining/PayCalendar2
They are formated as date/time and cint....I tried placing in the exported text into the generated insert statement in between the parens, but could not figure it out - below is the format that excell produces based on the export wizard (to a text file)
20050107 0:00:00,20041229 0:00:00,25,20050107 0:00:00
20050121 0:00:00,20050112 0:00:00,24,20050121 0:00:00
I am looking to do the insert statement sucessfully, and have anyone point out any problems if they see them...HELP!!!