Jump to content

SQLite and table names with spaces


Recommended Posts

Hi

 

I am trying to extract the contents of an Access database into SQLite so it can be downloaded and used in another app.

 

One of the table names has a space in it and if I can I would prefer to keep all the table and column names the same. However I cannot see how to delimit table names in SQLite to allow me to use spaces.

 

I have tried delimiting with `, [] and ", and all result in an invalid database.

 

All the best

 

Keith

Link to comment
Share on other sites

Double-quotes should work. Is there a chance that the name is all numeric characters?

 

I would convert spaces to an under-score

 

Double quotes do work for column names, but don't appear to work for table names.

 

In many ways I would prefer to use underscores, but would also prefer to keep the table names the same between the master copy and the SQLite extract copy.

 

I really wish people wouldn't use spaces in any table or column name, or any reserved words :'( .

 

All the best

 

Keith

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.