Cannot Export, Import, Copy/paste, Rename Table With Data!
Feb 22, 2006
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.
View Replies
ADVERTISEMENT
Apr 25, 2014
In the Contacts database, in the Report Center form are 5 links on the right pointing to some default reports.I have created several more reports, and want to just copy-n-paste those links and then change the 'Tag' so it will point to my new report.Can you not just copy-n-paste a field within the same form?
View 5 Replies
View Related
Jan 19, 2015
When I copy data from Outlook or MS Word that contains bullets or other HTML formatted text, into MS Access text control, the HTML tags are displayed in the tables.
The memo field in the table is set to Rich Text and so is the text control on the form.
Below is an example of the data I'm copying from Outlook email:
Fire Alarm Activation
Actual/Smoke Present
False
Planned Drill/Testing
Evacuation
2. Utilities/Power/Communication Failure
Now, below is what it looks like in my table or output in a report:
<ol>
<ol>
<li><strong>Fire Alarm Activation </strong></li>
</ol>
</ol>
<ul>
[Code] ....
How can I copy and paste and remove the html tags?
View 1 Replies
View Related
Mar 26, 2006
OK, here is a weird one, at least it seems weird to me. I have a field on a table, or query result, doesn't matter which, and it looks like this:"55264"25468"4562"123etc, etc.Now I need to copy that and paste it into the notepad in Windows. When I do that the pasted data looks like this:"""55264""""25468""""4562""""123"I have looked at it on the clipboard and it also looks like the above. I really need this data to paste to the notepad just like it is stored on the table (with one double quote only). It's one of those strange sounding things, please do not ask me to explain why...I just need it like that.Why the heck does the extra quote get added to the front and one get placed on the end?Test it yourself and see.Thanks
View 3 Replies
View Related
Nov 20, 2012
I am trying to copy a table and paste as another name. I do this all the time with this table as it is a process I have to do. It is giving me a -1524 error. I also tried to export it to another database and it won't allow that either. I get the same error.
I have tried this with other tables and it does fine.
View 2 Replies
View Related
Feb 16, 2006
I have an Access database with linked tables from Sybase SQL Anywhere, via an ODBC data source. I have just linked the tables recently, all the data used to be in native Access tables. It is fairly common for members of our team to open these tables in datasheet view, and copy/paste several records to create new records, then edit a few fields on the new records. This used to work fine with native Access tables, but when we try it with the linked tables we either get an ODBC error - "primary key value already exists" or the new records show up with #Deleted.
The root of the problem is this: In the old Access tables, the primary key was an autonumber field, and Access was smart enough to assign new ID's when you copy/pasted records. In the linked table, the primary key is type "Number" in Access, and Access is not smart enough to let Sybase assign new ID's when you copy/paste records in datasheet view. Access is trying to force the existing ID's into the primary key field, and Sybase says "too bad so sad".
Of course, I could just write some quick append queries to copy/paste the data. And in the short term, that's exactly what I will have to do. But is there any way, long term, to allow members of my team to do it the "quick & dirty" way by copy/pasting in datasheet view? I have tried to change the primary key to an autonumber field in design view, but Access doesn't allow that. Is there a way to do it in code, or a way to force Access to allow Sybase to always handle the primary key field?
View 1 Replies
View Related
Sep 12, 2011
I am trying to copy multiple rows (150+) and then paste them into the same table below the original 150 rows.I can only seem to get 1 row at a time.
View 9 Replies
View Related
Dec 11, 2004
Hi,
Does anyone know how to exclude the header information when copying a record from an Access table and pasting it into Excel. When I paste into Excel, it is also pasting the header information from Access which I do not want. I only want the data to be pasted.
Thanks for the help in advance.
BJS
View 1 Replies
View Related
Aug 25, 2014
I have an excel spreadsheet i want to copy and paste into a pre-formatted table, and the excel date format is integer YYYYMMDD or today is 20140825
I can't get the input mask in MS Access 2007 to create that !
View 2 Replies
View Related
Jul 17, 2015
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
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?
View 3 Replies
View Related
Sep 25, 2012
I would like to be able to copy a single record in a table and then paste this record a pre-defined number of times 10,20,30 depending on requirements. The reason I need to do this is that I want to set up a number of identical records that can easily be amended into unique records. This will vastly reduce the amount of work and time spent entering records individually.
The only way that I have been able to achieve this is to copy and transfer the master record into Excel, and then copy the row and paste it into a range of cells. Copy the range of cells back from Excel and then paste this range back into the Access table.
This works but is long winded; what I would like to know is is there a simply way of achieving this.
View 3 Replies
View Related
Oct 10, 2014
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.
View 2 Replies
View Related
Jun 25, 2013
This code is supposed to loop around a directory of photos (named after a project), and then copy a new photos (from another directory) to this folder, numbering them and the logging them in a table tphotos.The first time a copy photos to a new directory the code works fine. And I think I had it working fine before, but now when I copy photos to a pre-existing directory that has already photos, it only overwrites the first photo, instead looking for the last photo and attributing the new photo number n+1.
I've done debug.print in the code, and it looks like is not going into If NewFileName = f1.Name, therefore doesn't compare the newfilename with the files in the folder.
Code:
Private Sub cmdAddPhoto_Click()
Dim fs, f, f1, fc, s
Dim fDial As FileDialog
Dim SourcefileName, destDir, FileExt, NewFileName, prjID As String
Dim intSel, FileNumber As Integer
Dim varSelFile As Variant
Dim rsPhoto As Recordset
Dim myDB As Database
[code]...
View 5 Replies
View Related
May 18, 2007
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.
View 1 Replies
View Related
Sep 22, 2015
I am attempting to automate the import of a .csv file from a given directory and copy and append it to another table in a different layout. Below is my code. The error that i'm getting is it can't fine the copyobject in the database...
Option Compare Database
Option Explicit
Function DoImportandAppend()
Dim strPathFile As String
Dim strFile As String
Dim strPath As String
[Code] ....
View 14 Replies
View Related
Jul 16, 2014
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"...
View 2 Replies
View Related
Sep 9, 2013
How to Export and Import data into and from Access using a Quicken Interchangeable Format (QIF) ...
View 4 Replies
View Related
Jul 17, 2013
I'm looking for copy folder functionality and I can't find anything.
In access 2007 when I push a button on a form, I want to copy a network folder to another location and rename it.
View 1 Replies
View Related
Apr 5, 2006
Hi all,
I get information sent to me on email. This information then needs to be transfered onto a database. the information is always the same.
name *****
Date of birth **/*****
consultant ******
ward BLA ******
Is it possible to copy and paste all the information in one go from the email and paste everything into its correct places on a form with one action? This would save alot of time & effort on the users part.
Many Thanks
Samzie
View 14 Replies
View Related
Aug 4, 2005
To speed up my input I copy a record and paste it.
Only trouble is that I have one field in the table that is dependant on the parent table. [The customers email address which I populate with a query/combo box. There could be many, depending who the order was for.]
Q: What function could I use after the paste funtion to ammend that field automatially setting it to 'null'
Q: I looked into WM_PASTE but I'm really struggling!
Many thanks
Jon
View 1 Replies
View Related
Nov 2, 2013
I have a report (FI_ID) based in a query with the same name.
When i export this report to my desktop i need to manualy rename the filename.
What i need is a way to automatic rename my report to my text field value, called "Seq_Number" (it's a automatic number).At the end i will have 101.pdf, 102.pdf, 103.pdf in my desktop.
View 9 Replies
View Related
Dec 8, 2005
I want to disable the user from cutting/copying/pasting the value of a text box. What is the keyAscii of SHIFT as well as CTRL so on the keypress event for that textbox I can simply set it to a null.
Or is there an easier way to do this?
View 1 Replies
View Related
Feb 24, 2008
Hi Guys,
I'm trying to make a report where i will have a variable number of charts. My approach is to have one "template" chart, and copy and paste it at runtime, and then alter each new chart's properties (data source, etc) to suit
My question, and i'm sorry if it's basic, is how do i copy and paste my first chart (called "Chart1") as another control named "Chart2"?
thx for the advice
Rich
View 1 Replies
View Related
Jul 25, 2006
Copy/Paste
I have a textbox on a form that automatically shows the current date. Below that, I have 3 other textboxes for dates (each representing a step in a process). Often, the same date is imputed into each of these boxes. I would like to have an “Autofill” command button that would take the date in the first box and place it in the other three. This is so basic it’s hard. My usual searches turn up nothing. Any suggestions welcome.
View 5 Replies
View Related
Sep 22, 2006
Hi there,
I am a database designer for a UK Insurance company and have recently needed to rebuild our complaints database. One of the problems with the previous database was that staff were copying text from an application designed by Pacific Solutions (PACSOL). When the data was pasted into our Complaints database, it was causing some serious issues that made the database crash. This had started to affect people's confidence in our ability through no fault of our own. We then found out that this was due to the character set of PACSOL not being supported by access.
What we would like to do in the new database is prevent users from copying and pasting text into the system. Perhaps by displaying an error message when they press CTRL+V or do edit - paste.
Does anyone know how this can be done?
Thanks
Gareth
View 11 Replies
View Related
Mar 30, 2005
CAn i change the name of a field in a a folder from access. or better yet can i automate a file being copyed from one folder to another.
For example, lets say i have a folder named photo. i want access to find all the items that finish with a "f" and copy them into a new folder named "f_Photos"
Any Help
View 4 Replies
View Related