Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by linrudland
-
Insert into statement error
Hi Thanks for reminding about the date keyword. When I changed the field to text I changed the fieldnames to txtDate to remind me of the change and that I needed to fix the dev. database to match prod. Therefore the SQL worked. Prod has field prefix so it will be OK. Many Many thanks. Linda- linrudland
- Post #11
- Forum: Adobe
-
Insert into statement error
Hi I've got the same problem and error message. I've narrowed mine down to the date field by removing all the fields one at a time. It doesn't seem to matter what format I try (I am careful to match the table formats to the UD field format)it will not work. The dates are for a timesheet and are...- linrudland
- Post #9
- Forum: Adobe
-
Excel to Access data problem
Hi I've found that converting the file type from Excel into CSV normally resolves this type of issue. The text type format in Excel just does not seem to be recognized when importing to Access. If it doesn't work first time then force a wrapper of double quotes around the field and then try -...- linrudland
- Post #3
- Forum: Microsoft: Access Other topics
