I link too an Excel spreadsheet and then I want to export to Pervasive SQL, but first I want to massage the field names (replace blanks with underscores) and put an index on one of the fields. I can link the table and export fine, but I can't change anything. When I try to Save As it creates an MDB that is still linked to the spreadsheet. I can't find any way to get it to replace the linked spreadsheet with a backend MDB database so that I can add an index.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.