Hi Pat,
Thanks for the sarcastic and disappointing comments.
Perhaps you need to read my replies a bit better as I have been providing detailed information that you seem to be having trouble interpreting.
Thanks everybody for trying to help me but I'm signing off and will find a solution...
Everything has been working fine for a very long time.
Hi Pat
As I said it #19, without a Specification defined and outputting to a new table, ALL of the fields in the new table are defined as TEXT.
If I then rerun the Import without a Specification and point the output to the existing...
Hi Pat,
I re-ran the import via the External Data/text option with using a Specification and only specifying the "First Row Contains Field Names" and the text Qualifier. I then had it create a new table. All of the fields of the new table were TEXT.
I then ran the import again without a...
Hi Pat,
This is what I have just done:
1. The [AvailOrder} field in the Web_Parts table is defined as a YES/NO field.
2. I then ran an import (via the External Data/text option) using a single record without a Specification and it worked perfectly and the data from the AvailOrder field in the...
Hi Docman,
I changed it to "-1" but still get the error message when using a Specification but not when I don't use a Specfication.
This is driving me nuts................
I have tried "DoCmd.TransferText acImportDelim, , "Web_Parts", "C:\testmiport.csv", True, "" this and get the following error:
If I don't use a Specification, how does it know what the Text Qualifier is?
Hi Guys
My Access 2007 application uses DoCmd.TransferText option to import numerous CSV files into various tables and has been working well for years.
The want to change one of these Imports as there is an additional field in the CSV file that needs to be imported into the table. It is called...
This is the module that I use for creating the Audit Records.....
It does not allow me to use the Me.Name instead of Screen.ActiveForm.
Function LogChanges(lngID As Long, Optional strField As String = "")
On Error GoTo Error_Problem
Dim dbs As DAO.Database
Dim rst As...
Hi everyone,
I have looked and looked and can't find the answer to this issue so I am posting here hoping for some help.
I have developed a comprehensive Stock and Inventory system using Access 2007.
Here is the issue I have.
I have a main form called "BulkPartsMainForm"
It has a number of...
Thanks mate!
It works great!
I assume that SetParamter is not available in Access 2007 and this is a module that provides exactly the same functionality.
Thanks again!
Cheers
Greg