Who can help me out?? :confused:
I am looking for 2 scripts
1) for exporting an existing table with data to an seperate MDB file
(filename to be given by user using a dialogbox)
2) importing the MDB file (from question 1) back into the existing table in
the original database. Script does not have to worry for dublicate data.
Hello everyone.
I've been in a new position for a new company for less than three weeks, and I need some help.
The Access database that we use has been in operation since 2002, and it has never been Compacted/Repaired (I asked my coworkers and supposed IT people, and they said "what's that?").
After adding *one* new field, I've reached the horrific "error 3190" (max 255 fields).
I've tried all of the following, allowing at least 12 hours for them to run, but I cannot:
export the data to Excel
import the data into a new database
copy/paste the records (because there are 12100+ and the max is 9500, I think; and because of the way the dd/mm/yy converted itself to dd/mm/yyyy)
or rename the table with the data.
Please, someone help me.
Hello,
Does anyone knows how can I export the export/import specifications (which file/directory) and how can I import/export the specifications between different versions of Access. Thanks!
hi,
I'm having a small but annoying problem exporting data to excel and then importing it back..
The problem is that when i export a table to Excel - it changes the date format from dd/mm/yy (which is what i have in Access) to DD-MMM-YY (automatically in Excel)
This proves to be a problem because when i import the spreadsheet back Access gives me a data type conversion error.
Its easily solved manually by changing the field in excel to dd/mm/yy format but annoying as the user will have to do this everytime they export and import!
Any suggestions??
Thanks in Advance..
I would like to automate this daily process: In this order import or link, (not sure which is the best option) a fixed width table, add an ascending number to the end of each of the records, reverse the order, and finally export to fixed width .txt documents depending on the quantities in one field. There would be 3 text files exported, max.
View 4 Replies View RelatedI'm new to this forum so please excuss me if my question isn't in the right format.
I'm trying to export a database to a progam by the name of AA Planer.
I did a google on the phrase "access exprort AA Planner" and I got web page that said to "export the data in CVS format where Exel would acept it." So that brought me to the asumtion to export the data in CVS to import it to AA Plannner. Would I be right in making that asumtion.
Is there a way to move import/export specifications from one database to another?
View 5 Replies View RelatedI created a DB to track soldier information. Each month reports are due to Brigade. Each Company and Battalion has there own version of the DB. What I need to do is export data from the Company then import it to the Battalion. Then I need to export the info from the Battalion and import them into the Brigade. This information is either all new for a new soldier or updated info for an existing record for an existing soldier. I need to update all new changes to the info. What is the best method for doing this.
Also, when I try to export a .dbf, it pops up with an error saying there are duplicate field names. Im confused because ieach field name is unique.
Thanks for any help I can get.
Lt Butler
Ok,
I'm new to a particular access database that is having problems.
Basically, it is using transfertext to transfer a database to another file, at least as far as I know.
Unfortunately, it's hanging, and as best as I can guess, its because something in the export specification file is not quite right.
Can anyone offer me an explanation of how to edit an import or export specification file? The MS help seems to indicate that it stored in the database, but I haven't been able to locate the file that is specified in the vba code. Nor did I see it elsewhere in the folder where the database is stored.
Any help is appreciated.
-Jeff
Hi all,
I have an access Db that I use to manage contacts etc. I regularily send out newsletters and emails to the contacts in that Db.
I want to know if there is a way I can essentially track the emails from access in outlook.
eg. based on field "email" it can see the emails incoming and outgoing in Outlook and makes a new record in my table "communications" that also tracks phone calls and other comm's.
Tbls - Contacts, Communications, Company
It would be great if all email communications could just automatically be listed in the access table communications with a link to the email in outlook (not the actual email, only the subject line and a hyperlink to the email)
I have been scouring the web for something to do this and have found lots of kinda's or not quite's. I don't want to import my outlook email to a table if possible.
I run Outlook and Access 2003 (Office 2003) on XP SP2 box.
Thanks Heaps if you have any idea what I am after!
C
I have a database witch includes a continuous form (named frmExport). It could be very useful for me if i can find a way so to export data from access 2007 and then to import them into a word file.
Please note: The access data will be inserted into word table.
I have a few problems and I want them to be able to be done from switchboard:
1. Is there a way for me to export a particular report (after selecting it) to a closed excel template, that is formatted? It would open the excel template (that has a logo and column headings), export data to below the column headings, then save the file with a unique name?
2. Also, a way to import data from an excel file, after allowing the user to select file? Only data below the column headings mentioned above. Same data will be appended to existing table.
I am creating a ImportExportData macro that will link to my tables in the BE
However the BE has a password. I was told this would require coding.
I have even tried to 'convert macro to VB' and i get this:
Code:
DoCmd.TransferDatabase acLink, "Microsoft Access", "c: est.accdb", acTable, "Table1", "Table1", False
I then tried to enter the password in the last segment (StoreLogin) ie:
Code:
DoCmd.TransferDatabase acLink, "Microsoft Access", "c: est.accdb", acTable, "Table1", "Table1", False, "PASSWORD"
but that didn't work either, i got a "An expresiions you entered is the wrong data type for one of the arguments"...
How to Export and Import data into and from Access using a Quicken Interchangeable Format (QIF) ...
View 4 Replies View RelatedI'm building a data base for my company, which is composed of items we sell. I then need these records to populate our pricebooks, which are excel worksheets, under multiple workbooks.
So essentially, I would like to have all the fields separated by vendor, series and series items, then populate the proper Excel worksheet (within a supplier's workbook). I have the know how to build a query to narrow down a particular vendor/series/groupofitems, but I don't want to be creating an enormous list of queries which have to be run each time.
I also have the know how to create a joined table which pulls the item list into the proper group, creating one large table with every vendor, series, and items. But what I'm looking for is some type of hybrid, which will allow me to export all of the items to their corresponding worksheets in one fell swoop. This will be done regularly as prices from suppliers change, certain colors are discontinued, sizes added, etc.
I'm guessing when I use the query which creates the large table with all the product that it's indexed, and that I would be able to use this to then import the data into excel/export the data to excel. But I'm not sure about this.
I am trying to create an ODBC link to a copy of the Northwind data base.I am running Win7 on a 64 bit operating system but am keeping office running as 32 bit for Access, Excel , Visio etc due to the fact that I have a lot of old apps tied to them.
When I attempted initially to create a new system DSN ODBC connection it only allowed me to use SQL drivers. (No plurry good) So after some searching I found out that I could use a file in C:WindowsSysWOW64 called "odbcad32.exe" which has allowed me to view /use the total list of drivers to import data.So I can set up a DNS ODBC named Northwind1 and I can access the database without problems using Excel.However if I try to use the same ODBC link in Access to connect to Northwind1 I get the following error message:"You cannot use ODBC to import from export to, or link an external ?Microsoft Access or ISAM database table to your database".
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.
I am using MS Access 2002 sp1 and trying to export a table into a text file. Table has a numeric field with 4 decimals (Ex. 2.5972). Field size: Double, format: General number, dec places 4.
Only 2 decimals are exported to a text file no matter what I am trying to do. Is this a bug or there's a trick I need to know how to do it right?
Thanks for any help!
I have an access 2003 table I want to export to a text file. I can do this but the headers disappear and don't export. I can't find anyway to make the headers export also. Can someone help please.
Thanks
The transfer spreadsheet function only allows one to export a table from the database to an excel file format. I want to output the table to a file in csv format using a simple function. Is this possible ?
View 1 Replies View RelatedI have a table called "MPI_CODE" it has 4 columns. How can I export this to Word? By creating a new document first (Using Save dialog) then exporting that table to the word doc. Mainly looking for the code to export the table into word.
Thanks in advance for your help.
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.
Thanks!
Here's another question similar to my previous. Is it possible to have a macro prompt me for the path to a specific file/table I want to import?
Thanks,
SKK
I have two tables of different structures. Both have sys=autoincrement as a unique record identifier. What is the best way to blend the two tables into one? Should I change the field structure of each table so that they match up for a file export and import and if so how do I handle the fact that each table currently has it's own record identifier number.?
View 5 Replies View RelatedHow do I export a table from Access into an already existing Excel workbook on a specific tab, without erasing what it written on the other tabs?
View 3 Replies View RelatedI have four tables in a single .MDB file. I need to export the contents of the Design View of each table to a text file. How do I go about doing that? I've tried the help files and Access for Dummies, but neither are giving me the info I need.
View 3 Replies View Related