Hi.
I have a db, where the main table is linked via an ODBC connection to a SQL server db.
Want I would like to do is, either by code or a macro, import the information from the ODBC link , rather than "File", "Get External Data" etc etc.
This way, the code or macro would run everytime the db is closed, and the information is stored in the db as a table..... just as a backup
I have tried the various "Transfer Database" with macros, but nothing seems to work
I don't know whether this would have any bearing on the answer but I do not have write permisisons on the SQL server, and it does not have a primary key.......as far as I am aware.
I have a table by name "newtab" and I was trying to import a tab delimited text file "newdata.txt" into newtab. The first line in the text file are the column names: SSN, Lastname, FirstName (all tab delimited though). The same field names exist in the destination file. However I am getting the error which says the "the field name SSN Lastname FirstName does not exist in the destination file" What could possibly be the problem? Since the field names are not separated in the error message, could it be that it is seeing all 3 field names as one and therefore cannot match them to the destination fields? Does that mean TAB cannot be used as the delimiter? Using the interactive IMPORT from access directly for the same files work really good though. However, I would like to do this programmatically since the files would be coming in weekly for me to load and they are many such files. The command I used is as below. Please I need help.
I want to import HTML data which I get with email, to MS Access (2007). The problem is that files are badly formatted and standard import options are not avaliable for me.Basicly part of a file looks like that:
Before and after that there are many lines of code which is useless to me. Is there a way to access "Name", connect it to a row in my Access table and insert it's value (John) into the table?
I'm trying to import a few tables from a FoxPro database into an Access Database using VBA code. I know I have done it before and I remember struggling with the format last time.
I have the following piece of code for importing the .csv files from a selected folder and then renaming them into 'imported & filename' if succesful and 'failed & filename' if import failes for whatever reason (bad formating, etc.).
The problem is that the first time it encounters a 'bad' file after another, instead of going again to the Error handler, the command
gives me the default MS Access error, namely 2391. I would like it to go the the Error_handler again ang follow the course of actions and rename the files into 'failed' and 'imported'.
Here's the code:
Sub ImportActivitate() Dim strFile As String 'Filename's Dim strFileList() As String ' File Array Dim intFile As Integer 'Number of files Dim filename As String, sFullName As String, sFilename As String DoCmd.SetWarnings False
[code]....
Also, how can I make the routine stop cycling through the files after I renamed them all?
I want to make a database of diseases (need to learn them for school and would like a serchable database on my smart phone for future reference). Unfortunately spent a lot of time making hundreds of pages of word tables before i realized a database would be better. See attached image or pdf. Is there a way to import the tables to Access?
I need to preserve the hierarchic info in the nested bullet point lists. E.g. under treatment i might have a point called Acute treatment, with sub-levels, Step 1, Step 2, etc. with their own sub-levels. I need to maintain this relational hierarchic info.
Works great, but when I hit the number "3", (3 times in row) it will let me into the form. I want it to not let me in IF I don't know the password.
Where did I go wrong?
Private Sub Form_Load() Dim pw As Variant
If InputBox("What is the password?", "Password") = "1" Then Else MsgBox "Invalid Password", vbCritical, "Sorry Charlie" DoCmd.Close If InputBox("What is the password?", "Password") = "2" Then Else MsgBox "Invalid Password", vbCritical, "Sorry Charlie" DoCmd.Close End If End If
I protect my code from people being able to read it by setting a password on the code from Tools > Properties, selecting the Protection tab and entering a password, and clicking "Lock Project"
Is there a way to write code that will remove that Lock Project check and check it back on?
I've looked through the Application.SetOption command and it doesn't seem to be one of the choices. It would be very helpful if someone knew how to do this.
At the moment i am trying to produce a button which my users can click on to import some data from Excell to Access.
When i just go through it manually, ie file> import etc, the table fom Excel appears in access perfectly, but when i try using my button it brings up the following message:
Field 'F1' doesn't exist in the destination table 'Sheet2'.
The button runs off a macro. This is what i have for each option:
Action:TransferSpreadsheet
Transfer type: Import Spreadsheet type:Microsoft Excel 3 Table name:Sheet2 File name:the file location Has filed names:No Range:
I would be grateful if anyone could help and let me know where i am going wrong.
if you import using external file/import access just constructs tables of each individual xml tag, populated with the various values, not linked in any way
how do you get an invoice table, and invoice line table, etc, populated with appropriate data.
I guess this will be my last plea for help as to why an xml file will import the data into access 2003 (on my home PC) but not import the data, only the fields, on my work PC.
In both importings I'm indicating to indicate data and structure. Could it be the difference between versions? Perhaps a restriction at the end of my work environment?
I am not sure if this topic has been coverd in access-programmers forum but I'll ask any way.
I have thousands of records stored in excel (1NF). I have a access db to improve the need to have so many records duplicated.
Is their a way, via an action query (if so what one - update, append, cross tab etc) or another method to import the records and put them into related table.
For example, the current 1NF record columns are as follows >
Of course as organisation is the parent table, their is no problem doing a simple cut and paste, but i can work out how to put related records in a related table. Can you help?
Not sure where to post this question, so I put it in the general section,
I have an old db that i would like to import into a new be db of a newer version i wrote of this db. Is there any way something like an append query will add the records from one database to another?
or do i have to import then append then delete?
I have read several posts on this forum reference importing but all of them are from excel spreadsheets. Can this even be done??
I have been asked to recreate an existing database which was done in FileMaker into Access. Rather than re-enter all the data which is in there, can I just import it into Access? I tried exporting the FileMaker data into Lotus 123 format and then inporting it to Access that way. Filemaker has a bad habit of not exporting duplicate entries. I need this data as well. Any suggestions would be greatly appreciated.
I have got a Microsoft Access Database table with a few hundered records, I have got a excel or csv file with the same table but its got changes, deleted records and new records added.
What I want to do is replace the info in the access table with the new data that I want to import in. But I don't want duplicates and I want it to add, delete, modify records.
I know in MySQL you can use a Replace Query that does what I want. But the database I am working on is Microsoft Access.
Is their a solution in MS Access that I can tell it to point to a Excel Spreadsheet, or csv file and replace existing records with the changes, delete and add.
I need to import a form to an access 2007 database (from another access 2007 database) but on the External Data menu group, under the Import section, the Access option is greyed out (all other options are available).
I performed this same function yesterday and the Access option wasn't greyed out.
I've also opened up yesterday's backup of the DB and the Access option is greyed out in that too...
I am having to import data from a txt file on a daily basis. The date format in one of the fields is:30-Sep-2004 09:40:57 PM EDT. I want this to be in a short date format. I don't care about the time at all. If I try to import the data with this field set to Date/Time (regardless of format) it simply deletes the data in that field and goes to the next. If I import it as a Text field, it brings the date in as above.
Once the data is imported to the table, I can change the property of the field to Date/Time --> Short Date and it does the conversion. Is there a way to do this conversion automagically? I can't quite get any of the queries to work.
I'm trying to import some data from an excel sheet to a table in my database. The import wizard won't allow me to import the data into an existing table, only into a new one which is a nuisance. The data formats are the same. Any idea's what might me wrong Please.
I have lots of CSV files that are per day and are as follows:
File 1:
Username Time Bob 2 Joe 6
File 2: Username Time Joe 8 Sue 6
Essentially what I want to do is import each file into one table where if the username is not in the database it creates it, if its already in there a new column is created with the date. I dont mind creating multiple tables for each date and merging them.
So after those two files above were imported my table would look like this:
Username Time1 Time2 Bob 2 0 Joe 6 8 Sue 0 6
There are not many individual dates for that to be a problem, but there are over 5k different usernames in each file so I can't eyeball anything lol.
I am fairly new to access, but I am seasoned in MYSQL and Oracle. I've done some light searching on these forums and have not really come accross anything I need.
I've searched and searched but can seem to come up with an answer for my particular problem. I have a dbf table (well two actually but lets keep this simple) that are in a different location every day (folder name based on date). I came up with the following code but i get "Access can not find the database you requested. check file name". I've used this in the past with not problems (a simpler version anyway). Since I've used it in the past, I've changed computers, is there a setting problem I'm missing??
Here's the code:
Private Sub ImportInvpertDBF_Click() On Error GoTo Err_ImportInvertDBF_Click
I have the module for Path=ahtCommonOpenSave working in other imports fine so I figure that's not my problem.
The dbf files are comming from a field collection crew daily and I just want them to have a one click option to find the dbf's and import them into the DB.
I'm importing data from a spreadsheet to a new table in access. After the import, there are 10 empty records added at the end of the table. I think this has happened before but I don't remember why. Any ideas? Thanks!:confused:
I have MANY scanned image (.tif) files in multiple folders based on certain criteria. I need to find a way to import only the names of these (.tif) files into a table or even into an excel spreadsheet. Since they are scanned images you can not do a simple copy / paste.
I would appreciate if anyone has any ideas how this could be mastered
