Recent content by Dave32

All, I have now manage to print a report of all the data types and compared them will my Excel file. Everything seems to match up, BUT I am still getting the same errors. Can anyone help me interprete the error messages? Dave32

I am using Access 2007, and cannot see where I select the data type. Anyone using 2007 and can help? Dave32

All, I am appending an existing Access table from an Excel spreadsheet. I get the following error messages: "subscript out of range" "type conversion failure" Field F7 Row 14 "type conversion failure" Field F7 Row 15 "type conversion failure" Field F6 Row 24 "type conversion failure"...

All, This morning, I thought I found the solution, I did the following went to the "Design View" of my table Selected "Data Type" as "Currency" went to the "Field Properties" box In the "Format" cell I put "$#,##0" (yes, remove the speach marks), this is for $ and no decimal places...

Pat, Can you explain the syntax for the Format() function and where do I put this formula? Dave32

I am imported data from Excel into a new table. Firstly I get a data type error Type Conversion Error, Field F6 row 24 Type Conversion Error, Field F7 row 24 Type Conversion Error, Field F6 row 25 Then in the design view I cannot get Access to display the currency symbol "$" before a...

All, I cannot change the currency to display as $'s. In the drop down box in Access, I can only choose £ and Euro's. Can anyone help? Dave32

Pat, Thanks for your reply very helpful. Another question do you have to have the same amount of fields in both Excel and Access? Dave32

Neil, Thanks for your help. Another question, do the number of fields in the Excel sheet need to be exactly the same as in Access? I am not importing data for all the fields in Access? Regards, David

All, I want to import an Excel worksheet into Access. I will use the Import wizard in Access. In Excel, I have some cells formated as "General" the contain text. However, in Access the data type is "Text" as I cannot choose "General" is that going to cause problems? Do I need to change...

Hi all, I am having problems importing data from Excel to Access. Do all the fields in Excel need to be in the same order as those in the Access table? Also, The number of fields in the Excel sheet is less than that of Access, is that a problem? If I need to reorder the fields so there...

This is what I mean (see attached file). So current my fields are called " month + country code" ie FRANCE JULY etc... Ideally I want to create a form like the above as well. So you can input the data easily. I have tried this but it looks messy in the form as the field names are long...

All, Thanks for your replies. The database is store details of Marketing Campaigns. Each marketing campaign may have several Marketing Activities. So each row of data, i.e each record is represents one marketing activity. The generic data I collect is about 105 fields (this is info about...

I have over 270 data fields which are unique. I tried to store these all in one table but there seems to be a limit of 255 fields. I reduced the amount of fields to 230. I then created another table to add more fields, but I could not add many before I got the message "too many fields" Is...