How to convert XLS to MDB and add an index?

[mike1reynolds]

When I load a spreadsheet I can't add an index because it is a linked table, so I want to save it in MDB format so that I can add an index and then export it to SQL. However, when I save the file as an MDB file the data is all still linked as a spreadsheet and I still can't add an index. (I would add the index at the last step in SQL, but Pervasive SQL is very temperamental.)

Basically I just want to export an Excel spreadsheet into SQL and add an index.

 

[Moniker]

Don't link the Excel table. Import it. (File -> Get External Data -> Import instead of File -> Get External Data -> Link)

Importing makes a table out of it, whereby you can index whatever you want.

 

[boblarson]

And if you want to eventually import it to SQL Server, just do it directly with a DTS package and bypass putting it into Access.

 

[mike1reynolds]

I'm using Pervasive SQL, not Microsoft and they don't have DTS.

Thanks Moniker!!