×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

How to save linked table too MDB so it can be modified for export

How to save linked table too MDB so it can be modified for export

How to save linked table too MDB so it can be modified for export

(OP)
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.

RE: How to save linked table too MDB so it can be modified for export

Create a local unlinked table with the fields you require.
You can populate it with DoCmd.RunSQL "INSERT INTO yourtable SELECT * FROM linkedtable". Now you can do whatever you like before sending the data where it needs to go. (Don't forget to DELETE between loads)

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

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.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close