I know it should be enclosed like this [#] But they are not
So I have been trying to do an update query with no luck.
Any help would be great
Thanks in advance
I know it should be enclosed like this [#] But they are not
So I have been trying to do an update query with no luck.
Any help would be great
Thanks in advance
There is not enough information in this post. How about an example of the data, which I assume is in a text file, at the very least, along with what error you're encountering when trying to import the file.
In your query criteria, use Like "[#]*" and it will find fields beginning with #.
Here is a sample table
And here is a query
and here is the resultCode:SELECT Memotbl.id, Memotbl.fld FROM Memotbl WHERE (((Memotbl.fld) Like "[#]*"));
Code:
id fld 22 #78 has always been lucky for the Platzberg family. Starting with Friitz iin 1767, he won lotto max worth $78 Australian.
I'm trying to import data from one table to another like this
INSERT INTO table1
SELECT table2.*
FROM table2;
But when there is a # in the memo field they will not import. I have removed it from 10 records and they imported just fine.
So I'm thinking I need a query to ether import the records as they are or a query to remove just the # from the rest of the data.
I created two tables
[code]Table1
TID Field1 Field2 Field3 (Autonumber, text, date, memo respectively)
I put in a record
Field1 = "TEST DATA"
Field2 = 1/1/2016
Field3 = # TEST THIS and a bunch of random characters
Table2
TID Field1 Field2 Field3 (Number, text, date, memo respectively)
I ran a query appending all records from table1 to table2 with the number sign in the memo field (field3) and it worked just fine.
I also tried combinations of memo/text
Table1 Text, Table2 Memo (field3)
Table1 Memo, Table2 Text (field3)
and that also worked
Both of my tables are local tables. So again there is not enough information about your setup, please be as complete in your description of the problem so we don't have to do all the work for you.