General discussion
March 12, 2002 at 01:40 AM
dana803

DataType greyed-Excel 97 to Access 97

by dana803 . Updated 24 years, 6 months ago

We’re trying to import an Excel 97 file into a new table in a blank Access 97 database. During the import process, there is the window that allows you to choose the data type. It’s greyed out but has Double in the field. We want it to be text or a simple number. Even if we change the type in Excel, it still displays as a scientific number in Access and won’t let us control the data type. Any ideas???

This discussion is locked

All Comments