randolphoralph
Registered User.
- Local time
- Today, 03:14
- Joined
- Aug 4, 2008
- Messages
- 101
I have a excel spreadsheet with a header row and 8 columns
Column A-C are set to text format
Column D is set to Date format (3/14/2001)
Column F is text format
Column G & H are set to Date format (3/14/2001)
When I try to import this into a new table it changes the date to a 5 digit number (Ex. 39780)
I am not sure what I am doing wrong and have tried several different formats to fix this and nothing seems to be working.
Anyone have any advice?
Column A-C are set to text format
Column D is set to Date format (3/14/2001)
Column F is text format
Column G & H are set to Date format (3/14/2001)
When I try to import this into a new table it changes the date to a 5 digit number (Ex. 39780)
I am not sure what I am doing wrong and have tried several different formats to fix this and nothing seems to be working.
Anyone have any advice?