Importing Problem From Access

[dvannoy]

I am importing tables from access..I have a few fields that are short time. When trying to import SQL would not accept the import because of that fields format. so I changed it to text and removed the input mask.

The table imported fine. Now in SQL i want to change it back to time. so I tryed changing the field to a timestamp. and I lost some data. I also tryed changing the field to shortdatetime. and it did the same thing.

How can i make this work.

Thanks in Advance DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[jhall156]

timestamp is a binary number guaranteed to be unique within the context of a database. The smalldatetime will have a date component in front of it. If you have a date field associated with the time field you may want to just add the time detail to the field, otherwise you will probably be better served leaving it as text. I started out with nothing, and I still have most of it.

 

[dvannoy]

I was having access stamp the time for me when users would do certain things. So the time never got entered manually. If I use the smalldatetime can I strip the date from that field?

Thanks DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[jhall156]

you can convert the smalldatetime to text and then strip it. But what's the point? When life gives you text...


You can still get any functionality out of the text that you could before. It may be harder or at any rate different, but it will work. I started out with nothing, and I still have most of it.