Discussion Locked

Import Data types into SQL From Access

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi

I am trying to import data from a MS access db to a Sql Server 2000 DB however one of the data types is Time (eg 11:15) this will not import into SQl as a Timestamp or even a Smalldatetime. I can import it as text but then I cannont convert itto DateTime later. Does anyone have an Idea how I can overcome this problem...Perhaps a sample SQl I can use.

Thanks

3 replies

by bob sellman

Since there isn't a separate data type in Access called Time, I assume that you have set a format for the column in Access to display a short time.

Try eliminating all formatting from the column definition (so the only info about the column is the type of Date/Time) and then try importing the table definition and data into SQL again.

by gzwanepoel

Thanks Bob, at first it would not work by only making the change in Access, however combining this with importing it to SQL in datetime and not smalldatetime data type worked. Thanks a million!

This discussion is closed to new replies.