microsoft.public.access.externaldata | Forum profile

  Thanks Jeff I'll post back if I have any luck. Cheers and thanks again Tony "Jeff Boyce" wrote: > Aside from that puzzling last couple of characters, I believe you could use > an Access function that converts a string-that-looks-like-a-date into an > actual date/time value. > > (and I suspect those puzzling characters are the truncated version of what > originates as...

  Where? ... as in where have you "tried deleting all blank rows"? Regards Jeff Boyce Microsoft Office/Access MVP "kza40381" <kza40381@discussions.microsoft.com> wrote in message news:9A2586DF-1B21-47D5-AB27-61768986C7DB@microsoft.com... > Hi, > > When I link my Excel tables to my Access db, I am showing extra records in > Access which are blank records in...

  I think you are right that the merged cells are the problem. I think you should ask this in and excel group for more info on how to do the import and avoid the problem. "clk" <c.kurutz@comcast.net> wrote in message news:8ced5ffb-36e2-434b-8d3f-467c9cfc2a6e@r32g2000vba.googlegroups.com... > Hello. I have an Excel template where I need to export data from an > Access database (version...

  Sorry, there's no built in command. Chris Tony Williams wrote: >Thanks for such a quick response Chris. That worked just fine. Is there >anyway I can force it to show Excel files only in the files to open box? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200901/1  

  Or you could do something like this, which requires an import specification, but no other references and especially not the Scripting Runtime. Public Sub ProcessDirectory(ByVal strPath As String) Dim strFileName As String strFileName = Dir(strPath & "\Data*.txt") Do Until strFileName = "" Debug.Print strFileName DoCmd.TransferText acImportDelim, "Data1 Import...

  All you need to do is format the field as a date. Under the covers, Date values are stored as eight-byte floating point number where the integer portion represents the date as the number of days relative to 30 Dec, 1899, and the decimal portion represents the time as a fraction of a day. ?Format(39644.276782, "dd-mmm-yy") 15-Jul-08 ?Format(39637.275718, "dd-mmm-yy") 08-Jul-08 ?Format(39503,...

  When I try to copy and paste data from Excel to Access (2007 SP1), I get the following message:- "The data on the Clipboard is damaged, so Microsoft Access can't paste it. There may be an error in the Clipboard, or there may not be enough free memory. Try the operation again." There's no lack of memory that I know of - anyone have any ideas what is causing this?  

  The data is currently displayed in a row, of which there are 3,000 rows of data. Each row looks like: 12/01/06 $2,000.00 Cisco Switch for new network I want to have each of those items in their own column. The data is not separated by commas. It appears that they are tab delimited. Thanks for your input. "Jeff Boyce" wrote: > You provided an example of what you want. > > What about an example...

  I failed to mention that 15-Jul-08 and 08-Jul-08 also includes a time; but 25-Feb-08 does not include a time. "ttp" wrote: > I am importing an Excel file which contains a field with dates of the > following format: DD-MMM-YY (15-Jul-08). The table is imported as a text > field and the data is not displayed as shown in the table. For instance, > 15-Jul-08 is showing as 39644.276782 and...

  I have the same problem. Date imports from text data files that worked in access 2003 do not work in 2007. I found this solution on another website The only solution that I can find is to convert the text data to a date. The only workaround I can see is to import that data into a table with the date as a text field. You then simply run a update query to send this data to another column in the table (or simply build a expressin that...