microsoft.public.access.externaldata | Forum profile

  Since you are using fixed width, use the String function to add leading spaces. For example if a LastName field is a maximum of 20 characters, something like this in a query: TheLastName: String(20-Len([LastName])," ") & [LastName]

  Use calculated fields to be the right-aligned columns. Here's an example of how to write the calculated fields: FieldName_Calc: Right(Space(SizeOfFixedWidthColumn) & [RealFieldName], SizeOfFixedWidthColumn) So, if the width/size of the fixed width column were 20: FieldName_Calc: Right(Space(20) & [RealFieldName], 20)

  "ELENA PICCOL.O" <prova@exampl.com> ha scritto nel messaggio news:... >com iam .  

  Hi, I'm back. Just to say that my problem is solved. I uninstall the Access 2007 Developer Extensions (I don't know what was wrong with it). After that, all is working as supposed. Antonio "d_nu_b" wrote: > Hi, > > > I'm using Access 2007. When I import a Dbase III file (Ribbon/Open/dBase > III), the file imports with no errors, but float numeric dBase fields shows...

  "io" <someone> wrote in message news:... > > "io" <someone> wrote in message news:... >> >> "Kenny G" <KennyG@discussions.microsoft.com> wrote in message >> news:5D373F84-50C1-4933-9EEF-4DF5C32C58D9@microsoft.com... >>> Ms Gina, >>>...

  Hi Jerry, Thanks for getting back to me It is any spreadsheet they try to import to Access. They import their spreadsheet manually ever time. This is only happening to 4 users in a corporate office. I have try reinstalling several times with no luck. If the users goes to another computer they are able to import the spreadsheets with no problem. It is just their own PC that are having the problem. This just started happening about a...

  Problem solved..... DoCmd.TransferDatabase acImport, "ODBC Database", "ODBC;DSN=Visual FoxPro Tables;SourceType=DBF;SourceDB=z:\temp\;Collate=Machine", acTable, "sampleus", "Importzzz" "Redelman" wrote: > All - I am looking for a little help. As part of a larger application, I > need to IMPORT (not link) a FoxPro 2.6 DBF into a...

  ?ɭ?˾?ҵΪ?ѽ?ר?ž?Ӫ?ֲ?ҵ?ý?ճ?Ʒ?˾ƾ?ȫ?µľ?Ӫ??õĹ?ģʽ?ǵ?г?ҵ?Ͳ?ڿ?ٷ?չ?ģ?γ?һ?Ӱ?֪?ȡ?£?Ͽͻ?֧?֡?Ϊ?˸?õ?Ϊ?ͻ?ṩ?ݵķ?Ϊ?ͻ?ÿ?ÿ?Ҫ?ṩ?ƴ𰸡?ư? ?Ƽ?µļ?˵IJ?Ʒ?ټ? ?Ʒ?ͻ?ʹ?ù?⡣ ?ϵ?绰?13225699316 .  

  Is it possible to link a single spreadsheet to multiple tables. I have a excel spreadsheet that contains with 22 columns of information. I would like to link the spreadsheet to multiple (different tables), so that it will update the tables everytime I update the spreadsheet. If this is possible, instruction on how to will be greatly appreciated

  I have a DB2 Database that is used to store certain data related to work tickets. However, there is additional information that we need to track that is not stored in the DB2 Database. The DB2 Database is used by numerous divisions so we are unable to add field to accomodate all that we need. I can query the DB2 tables to pull the information that I need and export that into an Excel spreadsheet. I can then import that data into MS...