Link Table ? (from Excel)

[McWhorter]

When I link an Excel worksheet into access97 the data types are automatically set. How can change them to what I want since it says you cant edit the link table?

Lets say to change it from a "Number" to "Text"

 

[Klopper]

As far as I am aware it can't be done (at least not in the Link Spreadsheet Wizard)

You could convert the Excel spreadsheet to a .csv or .txt file and then use the Wizard to link this file to Access, or

you could insert the data from the linked Excel spreadsheet into a local Access table (with the desired field types) using an append query.

HTH
Klopper

 

[Guest_imported]

Another way: import the excel sheet from code to a local table (See DoCmd.TransferSpreadsheet method in Access help file). All data become text type.