I am trying to help a person that has a 1980s DOS database called "SMART". The program "smart" will output the database in a format that Access should be able to read, but it can't read the full file.
Any obvious ideas about what might be the problem?
I'm new to Access and VBA, for the record. What I need to do is copy a SQL database (table structures and records) and save it as a local Access database, so that the user can query and make any changes on the local file without editting the SQL database.
Looking around, it seems like the best option would be to use the TransferDatabase method with the acImport option. Does this sound reasonable, or can someone with more experience suggest a better way to go about it? Thanks.
Hello,
I have a database MS access: test.mdb.
Is it possible to attach to SQL SERVER 2005, or any other solution ?
I need to transfer all the application:
structure and data.
How to do it?
Thank
I imported an Office 2010 excel file into Access 2010. All the headers match.
All the data transfered, but the phone numbers.
In Design View, the phone numbers are listed as numbers, not text.
Then I tried to copy the two columns from Excel and past into the two columns in the database. No go. It did create a new table called Paste Errors.
How do I move that into the Table that I first created?
I need to know how to get the phone numbers in their because I need to import several other excel files into this table.
how i can import database files from ms access to visual studio?
View 3 Replies View Relatedhow i can import database files from ms access to visual studio?
View 6 Replies View RelatedI'd like to import an excel file but the data begin from cell "A10", above there is a "privacy text".Is it possibile import or link the excel data in an access table directly from the cell A10?
View 1 Replies View RelatedReading all mails from a Lotus Notes database, a view, a collection is not that difficult.
What I Need, but no where found is HOW TO Import the actual marked or opened mail, so only ONE mail, the current mail.
I have files that have extension of TSV which are text files but viewable in exel. I figured out a way for the user to click on a button in Access which does the following
1. Run Macro in Excel: The macro prompts the user to select the TSV file. After selection, macro opens the employee.tsv file in the excel (with excel being invisible) and saves it as employee.xls
Code:
Sub SaveTSVtoXLS()
Dim myPath As String
Dim myString As Variant
Application.DisplayAlerts = False
With Application.FileDialog(msoFileDialogOpen)
[Code] .....
2. Imports the Excel file (employee.xls) into two tables: tblEmployee and tblDepartment using the following codes.
Code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "qryDepartment", selectFile, True - 1, "A1:C2"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "qryEmployee", selectFile, True - 1, "A1:AE2"
Everything is working flawless except that the user has to select the file three times:
1 time for the tsv
2 times for the xls file
Is there a way that the user can select the file only once (tsv file) or at least only twice one of the tsv file and the other for the xls file?
I'm trying import some information from excel file into Access Database but I need have imported information formatted in specific way.
Import file is looking like:
City - Week / 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8
London / 3 / 1 / 4 / 5/ 5/ 9/ 1/ 3/ 4
Chicago / 2 / 1 / 4/ 8/ 3/ 3/ 2/ 1 / 5
Paris / 9 / 4/ 1/ 7/ 8/ 9 / 1 / 1 / 2
And i need table in Access looking more like
City / Week / Value
London / 1 / 3
London / 2 / 1
London / 3/ 4
London / 4 / 5
and so on for each city.Is there any option that this can be done within DB or It would need be some kind of macro to transfer this into other format?
Hello everyone,
I'm trying to import data from our current Database Pro v1.0 DB to an Access DB that I'm creating.
Our DBPRO is essentially a flat-file data entry program. It has a "subform" for history events that isn't actually in it's own table, but all concatenated in a single [History] field.
Basically, when viewed in DBPRO, it's broken into different records, yet it's actually stored as one. DBPRO uses °, ±, □, and 0's to separate the different "fields", but Access can't seem to break it down automatically.
When I export the data to a CSV file, everything else comes through with minimal problems. The [History] field, of course, comes in as a huge block of concatenated records.
I've attached an example of this below. I included only the field in question, ([History]), and the primary key, ([Last Name/Cust]). The first tab in my example is a single record, recently imported. The second tab shows how I need it to be, broken into multiple records.
Is there anyway I can split these records, while maintaining the primary key? It's my goal to have all the other information in one table, and the history records in a separate one.
Thanks so much for your help! I've researched all over, and just can't seem to find a similar problem, or solution. :(
Ben Bolduc
I just created a database and need to connect it to the data source. The data comes from a http website (intranet from work). When I open the link using firefox, I can view the website with the data in it, but when I open it from Internet Explorer, I get a save as pop-up message to save a csv file which contains all the data. The extension of the http website ends with csv. So it is something like http (slash slash...) Intranetname/referral_dbase.csv
Currently, I am opening the file using firefox, copying all the data manually, and pasting it in a text file using notepad. After that, I import the file into access. The delimiter of the data is this symbol: |
I am trying to find a way to link my database to the website where the data is located so that I can skip the manual process of opening the website and copying the data and saving it into a text file and then importing that file into access. I was thinking to have like a form in access with a bottom that will automatically import that data from this link and paste it into a table in access using the delimiter symbol mentioned above.
Is this too complicated? Is it even possible in access 2010?
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.
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??
Ricky
I have two databases. One is 'live', one is for development. Once i get something working in the latter, I import it into the former. This has been working fine for just over two months.
Today, however, i'm trying to import a form and get one of the following messages:
"The search key was not found in any Record"
"No current record"
I'm unable to import the form.
Any ideas what could be causing this?
Hi All,
I have a split database. One of the processes I've
created, copies a new table from a previously created
blank table. It then imports data from an Excel spreadsheet
into the newly created table. My problem is that now when
the import occurs, the data is getting imported into both
the new table as well as the blank table. For some reason,
this only occcurs after the database is split. I've tested on
a backup copy that is not split and everything works fine.
Any ideas please?
Thanks,
I want my access database to store information about "tests" and "products" that are in each "test". So "tests" is the "one" and "products" is the "many" (each test has many products).My client needs to routinely send me lists of tests and the products that are in each test. I then need to put this information in to my database
I don't want to type out the information they send me, instead I want to devise a simple form for them to complete and email to me (perhaps in excel) that they populate, and I then import/paste in to my database.How should the excel form be structured so that it is both easy for my client to populate and easy for me to import/paste in to my database. e.g. importing lots of test and product information, rather than type it in. Bearing in mind the 1:M structure.
Hi all, I'm trying to get the following done:
I have code which import Excel files into my database with the "DoCmd.TransferSpreadsheet". which works great.
But I'm now splitting the database and I want to have the Excel files which a user selects in his frontend database, imported in my backend database. I don't see the possibility in the TransferSpreadsheet as this is set to the CurrentDb.
My temporary solution is to import in the frontend and CopyObject to the Backend, but does anyone have a direct solution?
Thanks, Rob
I've posted this in the 'General' forum, but without success, so I'm trying here.
I have two databases. One is 'live', one is for development. Once I get something working in the latter, I manually import it into the former (File - Get External data - Import). This has been working fine for just over two months.
Today, however, i'm trying to import a form and get one of the following messages:
"The search key was not found in any Record"
"No current record"
I'm unable to import the form. I also get the same error messages if i try to copy and paste the form within its own database.
The form in question has a lot of lengthy code behind various combo boxes, text boxes, etc. When I attempt to look at this code (via right-clicking on a field and going to Properties and the Event tab), none of it is present any more.
What's going on? This form took weeks to get working and now it can't be copied, renamed or imported, plus it appears to have been 'wiped' of everything but the visual features.
Any ideas what could be causing this? Can one form become 'corrupt'? If so, please say that there's some way to remedy it?
I have a secure MS Access database, where users by default can only read data, but not write. How can I prevent them from importing or linking files, or inserting objects? I don't want to use any passwords in my database, since it's used inside the application. Thank you.
View 1 Replies View RelatedI have updated my copy of a database which included updates to a number of forms. I now want to import those changes into the proper database, so I used the Import function. I didnt get any errors when I imported everything, but the forms do not work as they did in my copy of the database.
One of the forms that dont work comprises of a number of drop down boxes, I have updated these so that the user has a filtered selection, to do this I put an SQL function in the Row Source property. This SQL function has been copied over correctly in the imported form, in fact when I go into the form in design view to check this fact then revert it back to normal view (after having not changed anything) it then works and all the other drop down boxes that didnt work on that form now work! How can viewing a form in design view and not changing anything make it now work?
So I could go into each form in the design view, check the Row Source property, then revert back to normal view and it would solve the problem of my forms not working, but, this database that I am importing the forms into is the back end of a split database and the first thing that the front end of the database does is import the changed objects into its database but the forms dont work.I have made changes in this way before and not had any problems before.
I had created a database a number of months back and received.After getting halfway through and seeing some requests come through from management on what they want to see or improvements, it looks as though there will have to be some retooling done to the database like moving some fields to different tables as there is duplicate entry fields.Would you import all the tables into a new database and then append the data to where it needs to go or keep working within the one I have?
View 3 Replies View RelatedI have a database for when our people are out in the field. The people will fill out large questionnaires that I want to import into our main database. How can I automate this?
View 10 Replies View RelatedAll, using access 2010 but working on a 2003 database. Trying to import a table from another database. I made a copy of a database im trying to import from a database on a production server and placed it in my development folder. When I go to import the table; it throw an error:Reserved error (-1524); there is no message for this error.why I can't import a table especially if no one is using it?
View 2 Replies View RelatedUsing access 2010. Trying to set up an import table from an external database.
Code:
DoCmd.TransferDatabase acImport, "Microsoft Access", "Y:DevTestFolder2013 01 Some Data Name", acTable, "tblName", "tblName"
I get an error 3024 could not find the file Y"DevTestFolder2013....
The database I am importing from is a 2003 .mdb
I tried the brackets because the file has spaces in it but still get the same error.
I want to import data in access or excel from snapshot file- *.snp. Can I?
10x