I’ve got a bunch of CSV .txt files from Access, each .txt file being a table. I can import them as an existing database in ‘txt’ format and they all come in at once OK. However, the tables appear to be a non-relational database. I can’t do joins, etc. and if I pull down Tools | Relationships… I get “The database does not support relations.”
Is there some way to import .txt tables in a way that I can build relations among them?
If not, what’s the purpose of even having a multiple-text-file import facility at all?
Is there some alternative recommended way to import an Access database into Base? How about the queries? Oh, I see, I can access the Access database directly?
But I’d still like to know how to have a .txt relational database. Thanks!