Search results

It is probably worth me adding that this is a better way to do what I am trying to do as it doesnt leave extra '0' in places that do not match 'B'. INSERT INTO TABLE1 ( Field1 ) SELECT 'X' FROM TABLE1 WHERE Field1='B';

Yep...that was it...I am just getting started with SQL for Access.

All, I am trying to create an append query based on data currently in a table. For discussion purposes, lets assume 'Table1' contains (A,B,C) in 'Field1'. I would like the append query to search for a value, 'B' in this case, and if present, create another record 'X'. Here is the code I...

Ok...ive decided to bring everything in without column headings. This will allow me to store all asset information in one table. Ive created another file that determines the channel information for each asset. What I would like to do next is set up the queries so that it will first request the...

I am starting to look at an approach that ignores column headings. Data will be read into the file for each asset. I was thinking about having a seperate table that specifies configuration for each serial number (along with the effective date of that config setup). I wasnt aware of the "text...

I should have mentioned that the files contain approximately 8-10 variable channels. These channels are configured for individual assets and that is the reason that they can change. As of now, I have a controlled population that is configured uniformly. I would like to contain all of the...

The files are just simple text files. Column headings on the first row and data starts on the second. The files come into the share drive via FTP as binary. I have a perl script that grabs the binary files and converts to text. Then access takes over from there.

Does access handle automatic column heading assigments for tables? I have files that I am importing via VBA. As of now the column headings are the same, but in the future, they will change. I would like to continue to import the files into the same database and have access automatically...

No, not how to trigger the process. I will have the process either manually started or set on some type of schedule. Currently, as I am working my way through this (and yes, I am very new to Access) I am testing this database "file maintenance" process manually. Sometimes it takes up to...

What is the recommended method for deleting records using a VBA module? Currently I am using an SQL method that specifies the table name and the upper time stamp date from which values should be deleted. My database is continually being updated with new files from this same VBA module. I...

Ok...looks like you all have been very busy...appreciate the discussion. I took vbaInet's suggestion and used CurrentProject.Path and now things are working great. I must have been doing something wrong with the CurDir as outlined above. Anyways, things are working great with...

All, I have limited experience with VBA but have used it in the past. I am currently trying to set up a module within access so that I can read the current files of the directory (.txt files) and then bring them into a database using "TransferText". I am running into one issue when using...