Some files can contain viruses...
"Some files can contain viruses or otherwise be harmful to your computer." How to disable the annoying warning message?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I want to update one of two files. How do I compare these two files. Both files should have same First and Last name . Id appreciate answers.
It is required because all the files will be moved from their current places to another file share so these accdb files will lose their connections to the linked files and they will become useless completely.
Somehow these paths need to be updated automatically. We are talking about hundreds of files, there's no solution to do it manually, it is impossible in a short term.
(1) When I convert each file to access it seems impossible to get rid of the root excel files. I guess that could be a blessing because it would be easy to modify through the root excel files. But I wonder if in the long run it might some way be a problem.
(2) I would like the primary key fields to be the plants names rather than numerical code and I wonder if that will work ok.
I tried to attach sample excel files to this note but my 2010 excel files were not accepted
in XP my installer program I made myself created a folder in the Program Files folder of the users computer and these files were saved there.
I then put a link on the users desktop to a small program that called the database.
Now we are going to big school now and I have to create a new installer for Windows 7.
So my question is where should I be saving my files.
I notice that if I now want to save files in Program Files the user is going to have to elevate my .exe or other program under UAC.
It seems that what I have to do now is save my files in two places. Static files that are only read can be in program files and then anything that is read and written to such as a userssettings saved in an .ini file would have to be in there own user folder.
I would like to make a parameter query to show files which were current at a particular time period - I.e. files that were received on or before a certain date (to be entered) AND files that were completed on or after a certain date (to be entered) OR files that are not completed (completed field is null).
The sheets I have looked at have headers and the data doesn't start till row 12 or so. Only one sheet per file.
Here is what I need to happen:
The excel files, all of them, would need to be opened and have a copy paste special to get rid of the formulas in the excel files, then saved.
Then all of the files in a specified directory would need to be imported into a specified table in access.
I don't know much about doing this in vb, but I am thinking that is where this needs to be done.
In the be I have the main db with fields required for the files and I have another database (table 2)with similar fields that I use to generate an email form that workers fill out to request files.
Access then automatically pulls that data from the email form and inserts in to table 2. I pull those requested files then enter the data in to table 1 so that I know the who/what/where of a files location.
I want to be able to automatically insert info from table 2 into table one after I have pulled the file and checked it out.
These files all have different names but will always be found in the same location.
C:\Documents and Settings\computer\Desktop\F FILES
I have little VBA knowledge and am wondering if I can import these files into an existing Access table tbl_Table via a macro?
A number of problems:
1. It does not import directly into the existing table, instead it creates a new table tbl_Table , I'd like to import directly into the existing table without using append or similar.
2. I cannot get it to import ALL files in the folder.
3. I'd like to import the first 7 characters of the filename into a field (KEY).
Here is what I am trying to do which will result in automatic import of files so users don't have to worry who imported last and where they left off.
1. Open all .xlsx files in the given directory, save them as .csv. (This part I have done)
2. Obtain a table with files that have already been imported (done)
3. Have Access compare only the .csv filenames found in the given location to the table and import using the TransferSpreadSheet method only the new files then add the filename to the table.
I can import all .csv files but need help comparing them to filenames in an existing table.
4. I'll then delete all .csv files in this location so it appears nothing has changed and write the macro so all the steps occur everytime the database is opened (this I'll work on myself)
Can anyone clue me in how to compare a filename to an existing table?