RE: External table is not in the expected format

From: Mohamoss (mohamed.mossad_at_egdsc.microsoft.com)
Date: 08/10/04 

Date: Tue, 10 Aug 2004 09:49:34 GMT

Hi Simon
Mostly there is some data type that is sent back to the excel file that is
not expected there. how do you import your file? . If you do any
modifications, make sure that you keep the parameters as expected by the
file.
Mohamed Mahfouz
MEA Developer Support Center
ITworx on behalf of Microsoft EMEA GTSC

Relevant Pages

  • RE: Importing Excel File Into All Text Fields
    ... TransferText wizard, click on Advanced. ... Thanks, Nancy ... and use whatever data type conversion functions are necessary ... create a table with the same fields as the Excel file and have them be text ...
    (microsoft.public.access.externaldata)
  • Excel Importing.... Fact or Fiction?
    ... I have an Excel file needs to export to an Access table. ... one worksheet and it contains 103 rows of data in 12 columns. ... and text data type of the zip code like "56124" or "56124-0014". ... importing to an Access table, the Access uses the first 25 rows of the Excel ...
    (microsoft.public.access.forms)
  • Re: importing from excel to access
    ... data type the query won't work right. ... "Ken Snell " wrote: ... Depending on the data that are in the EXCEL file, ... <MS ACCESS MVP> ...
    (microsoft.public.access.externaldata)
  • Re: linking or merging to Excel
    ... you can do the EXCEL save as via Automation. ... the data type is correct. ... Otherwise, you could use Automation to open the EXCEL file, read each row ... prior to importing but it still imports as a number. ...
    (microsoft.public.access.gettingstarted)
  • Excel Importing.... Fact or Fiction?
    ... >I have an Excel file needs to export to an Access table. ... >text data type format. ... >and change the row 26 to text data type and the importing ...
    (microsoft.public.access.forms)