Does anyone know how to import or link files from the Quickbooks Timer program? I've tried changing it to a *.xls file extension and that didn't work, tried linking vs. importing, etc.
Any suggestions?
How to Export and Import data into and from Access using a Quicken Interchangeable Format (QIF) ...
View 4 Replies View RelatedI 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
Code:
DoCmd.TransferText acImportDelim, , "Activitate", filename, True
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 get this message when I import dbf files.
"The Microsoft Jet database engine could not find the object suitability.dbf. Make sure the object exists and that you spell its name and the path name correctly."
Can someone help? Thanks.
So I've just started with a company where my job is to manage a ton of data. I am new to Access (2010) and am completely impressed by all the awesome things it can do. However, I am running into some issues with knowing the best way to get my current data (which is all in Excel spreadsheets) into Access.
We are working with about 68 customers in 6 different focus areas (or areas of improvement). To make it easier for them, my company has not required them to enter all their data for each area into a centralized database. Instead, we are pulling reports (into Excel) from 3 different databases. The customers who are not currently submitting data to these databases are sending us Excel spreadsheets with their data (they send a seperate spreadsheet for each focus area). So you can see where my problem lies ... NOTHING is the in the same format. Even then the Excel spreadsheets look different from month to month (and customers submit a new, updated form every month with the current month and previous months) because the people managing the data before I came along changed the format a few different times and the customer has the ability to change them too.
Basically, I would really really really like to be able to just link the Excel files to my database, but I am struggling knowing how to do that with my data in so many different places and forms.
How I would link to jpeg files and have access render them. How to do it.
View 2 Replies View RelatedI'm using Access 2013. I have a directory on my hard drive that contains hundreds of image files. The name of the image file matches a field in the Access table, which are unique. I would like to match those files to the unique number in the table and create a link in a field. How would I go about this.
View 12 Replies View RelatedHello all
this is my first post. I've tried to get my info without any luck so i ask my question here.... hope it's ok.
I want to import some dbase files that comes from an accounting software and ask Access some queries. The queries part is perfect. My only problem is how can i ask (in a general menu of my Access application) access to go and get those dBase files?
I want the user to be able to have a button asking him : " Do you want to import new data?. And then it will update Access. I don't need to append the data just overwrite the old data. I'm not doing any manipulation of data on the files, just asking questions. (Hope i make sense...)
They are always on the same directory on the server.
Thank you for the help!
Dear experts,
I need to import a csv file into a Access table. Some of the fields contain newlines, these field should go into a memo field (they're > 256 chars) which are to be displayed in a report later.
Unfortunately, Access (and also Excel) treat newline chars (vbCrLf) as field separators, resulting in a lot of garbage... I'm interested in one of three tricks:
1) find a way to import the csv file with newlines
- or -
2) replace the newlines by unused chars before import, e.g. by '#!' and replace them after the import in the table
- or -
3) replace the newlines, and re-insert them back in by an expression in a query or a report
I have succeeded to import the file with the newlines replaced. I did not succeed to re-insert newlines (at least not with "Replace"), and I couldn't find a way reconstruct the newlines with an expression or in a report.
Has anyone an idea or better trick to do the job ?
Thankss....
Hello, i have installed Access 97 from an Office 97 CD on a new laptop and when trying to import a table and browse to my file location i cannot 'see' any excel files to import, it only allows me to see Acess files or ODBC sources. it worked fine on my previous pc using the same install method. any ideas? -thanks Scott
View 4 Replies View RelatedI have made a form with different records now my goal is to filter those records and export the details of those records to excisting Word files.
So for instance:
Record filtered on:
Title: TrainingsSharepoint
Location: London
Than it wil export the details to --> Doc1.docx
Or
Title: TrainingSale
Location: Berlin
Than it will export the details to --> Doc2.docx
And so one...
The Word files already have some text in them so i want to set up variables to insert the details in the right place.
2013 does NOT recognize DBF files, we are trying to find a solid work around to LINK to our DBF files.
There are about 30 DBF files that get updated EVERY week. And there are about 60 employees that LINK to the various DBF files. Importing is not a realistic solution given these circumstances.
Every time I try to import a CSV file into my Access database it crashes. I've tried repairing it but the repaired database crashes as well. Any ideas on what could cause this?
Thanks.
Hello, i want to make a button on my form to input .csv files. What is the best way to do this? I simply want to click the button and be asked for the csv location, i want the csv to be imported and be formatted. Whats the best way to do this?
View 2 Replies View RelatedHi I have a few .csv files that i would like to upload into an access db. I saw an example for DTS, but since i dont have sql server i can't go that route.
Since i have some .csv Files where the file name changes on a daily basis, is it possible to upload them all with some wild card function. there is already a table with the fields already predetermined, and all i basically have to do is just load them all up at once.
please let me know if you have a solution.
hi i am trying to import a fe files that have a certain portion of the file name tat is the same.
Since i don't know the syntax in VB this makes it much more harder. I understand the logic, but writing is a chore.
can someone please look at this code and tell me what i am missing?
Code:Private Sub upload_Click()Dim strfile As Stringwirds = "D:RLConverterupload"strfile = Dir("wirds & *.csv")ChDir (wirds) Do While Len(strfile) > 0 If Mid(strfile, 1, 5) = Z56203 Then DoCmd.TransferText acImportDelim, "import spec", "data1", strfile, True Kill strfile strfile = Dir End If Loop End Sub
Super new to the forums and hoping I can find an answer here.
After looking for an hour or so on Microsoft's site, I gave up and decided to venture into new resources.
My ultimate goal is to create a form that will prompt a user to select a Microsoft Excel file and then run a macro. The macro should import the Excel file into a single table based off of what form is being run. The idea is to have a single form for each employee of a specific department and have the form import information that is stored on our phone server into access. I've set up most of the macro but the argument section of the filename is what's hanging me up.
So finally my question;
Is there a way to have a macro run to specify what file you want to import when using an additional macro? Am I going about this the completely wrong way and should stick to VB Code?
I look forward to your responses, thank you in advanced!
I have a form on access which allows users to upload csv files.
The files can be in any layout, so the field names and the number fields will always be different each time.
This can cause issues on data types, as access assumes a certain data type for a field, but the data may not always reflect that.
For example telephone numbers, access assumes this is a numeric field, however sometimes there will be symbols in this field such as +44. Which then causes import errors.
Is there any way to import these files without getting these sort of errors?
Currently the import process uses a simple TransferText method
DoCmd.TransferText acImportDelim, , "Original Data", Me.filelist.RowSource, True
This imports the data into a new table called 'Original Data'.
I had the idea of saving the table structure of the csv being imported (Importing the data with errors, then deleting all the records to just leave the structure) However I can't find a code to change the data types of that table to TEXT format, when I can't tell what the field names will be.
This whole thing is an automated process, which why there are loads barriers btw.
I've been asked importing about 50 - 60 .DBF files into an Access database daily - and processing the data in Access to specs I don't have yet.
I'm pretty comfortable doing whatever once I have the data in the Access Database.
I've been creating an automated way for users to import an existing DBF III file into an Access Table and then I'll be doing some other things after it's in. The user needs to be able to click a command button to open up a file picker, select the desired DBF and then click import and have it be imported into a new table.
Originally I had this all working because there was only one possible file name for the DBF file in each folder so instead of using a file picker I used a folder picker and supplied the file name in the VBA code as it was static.
However, I now need the user to be able to select a specific file and the name could be anything.
I've successfully edited the file picker to allow them to select a file however the importing is an issue. In order to do a TransferDatabase command I need the file path alone for DatabaseName and the file name alone for Source.
What would be the best way to split those two pieces of data up once the user has selected the file they need?
Not sure if someone has come accross this probelm but I am unable to link/import tables from excel or text files.
I am able to import tables from other databases but as soon as I want to import an excel file it seems that the import wizard simply doesn't exist.
re-installed office several times but to no avail.
Access/office 2003 running on windows 2000 sp 4
Microsoft help is no of use.
I am also running 97 on my pc and have no problems here.
:confused:
Hi
I have a situation whereby I need to create a db that will link to a directory of images, I have successfully got access to link to an image and create a record but to add 1 image at a time would be unproductive. The user should be able to highlight multiple images and then have access create a new record for each image (link). Any support or suggestions would be greatfully accepted.
Thanks
I accepted a month long job in putting together an Access database for a trucking company. I don't know how to make the incoming data know that it is related to its perspective field in other tables.Also, I am not understanding is how to link the tables. I have a main table with all the data. It is by date, and has all transactions, which Access assigned a number per transaction as the primary key. Then I have an Employee table (the truck drivers), a Customer table (the truck driver's company), an employee productivity table (includes wages, pay rate, Emp names, etc) and a truck table.
I tried linking the tables, but not sure if it is correct. I linked the Customer and Employee table via an EmpID foreign key in the Customer table. The employee productivity table is linked to the employee table via an EmpProd foreign key in the employee table. And the Customer table is linked to the truck table via a Cust foreign key in the Truck table. The table with all data is indexed to the Emp table, and under relationships the arrow points from the Emp table to the all data table, but there is no one to many (etc.) relationship because I did not know how to establish one. I tried reversing the arrow, but it wouldn't let me. I don’t even know the difference between an indexed link verses a relationship link.
The data itself is not linked. The Employees in the employee table does not know that it is the same field in the other tables. The all data table has EmpName daily info with only about 20 names, but about 4,000 fields. I listed the 20 names in the EmpName field of the tblEmp, but do not understand how to make both tables realize that it is the same field. It does not seem to realize that it is the same field because it does not rearrange the two field data with the correct data. I have this problem with all my tables.
So when I need to add the rest of the data, I don’t think the data knows where to go.
What am I doing wrong?
(I am using Access 2007 at work, and completed a class on 2010.)
I have 100 or so 2-sheet excel workbooks. I need to import them all into an access table for analysis. They are all exactly the same format/layout etc but obviously have different data in them (they are customer satisfaction surveys). I only want to export 1 out of the 2 sheets on each workbook (the other is a front end, the data sits behind in sheet 2).
So, at the moment I have to go to 'get external data' > 'import' > select excel and then double click each file individually and then go through the import wizard. Now, I can get them all into one table but it's clearly time consuming.
Is there anyway of doing a batch import of multiple excel files to cut out the manual work described above? Or can anyone suggest a lateral get around?
Any help much appreciated. I should say that I am running excel 2003 and access XP (2002)
Matt
I need to daily import files that start with same name, but the remaining part will be Bill of lading ID (e.g. TEST_BOL 1234.csv). The next day will be TEST_BOL 1235.csv) and so on. I need for Access to import the file based on the "TEST_BOL" into my database and then delete the file from the folder. I don't know how to initialize Access to look for the prefix and import in.
View 9 Replies View RelatedI have a folder that gets updated with a few new xml files every day. I need to import the data in these files into a table. The names of the files to import is in a field (FName) in a table (tblFiles).
The code that loads up the files is this:
Application.ImportXML DataSource:="C:ImportXML FILES" & FileName & ".xml", _
ImportOptions:=acAppendData
Up until now I specify the name of the file in an inputbox, so I have to enter a bunch of names to get it done.
I am looking for a way to get the filename from the table and then load up the file automatically.