Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Trying to export an Access 97 table to Excel
An other option might be to select an export that excel will import - (txt. or csv).- blanchj
- Post #3
- Forum: Microsoft: Office
-
importing data into MS Access 2003
Chris you are right. The data in the spreadsheet should contain -1 and 0 if the access field is a yes/no field. The default should be 0 and is false(no). By default the empty cells should import as 0. If you import from excel with a data type of numbers, and you then convert from number to...- blanchj
- Post #2
- Forum: Microsoft: Office
