How is a BRIO table (Section) imported into Access?

[LCH]

Need to import a large (70,000+ Rows) table into Access any ideas?
Have tried to Export as a .csv file out of BRIO and then Import into Access
- however a lot of the .csv file is rejected with errors due to fields
containing both numeric and non-numeric data, numeric fields containing the
formating (99,500.00) etc. Simpliest way would be if possible to connect to
the BRIO table from Access.

 

[Jeanette Cunningham]

A .csv file is the way to go.
If you can post a sample of a few rows showing the fields
with formatting that is causing a problem, we can suggest
how to do it.
Is this something that you need to do often, or just a once off?

Jeanette Cunningham

 

[wphx]

don't know if this might help - put in a couple dummy rows at the top of the
..csv file, with text data for each field. That way you might force access to
recognise the import data as all text, (including numbers). You can then use
queries etc. & crating new tables to receive the data in the correct
formats?

 

[M.L. Sco Scofield]

LCH,

What I do when Access guesses wrong on the data types during an import to a
new table, I build a table with the correct structure and then import into
the table.

If the problem is that there is actually mixed data in some of the fields, I
set the fields in my "import" table to text so that I can get a clean
import. Then I make update queries to fix the data before using it in my
database.

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, A+, Access MVP 2001 - 2005
Denver Area Access Users Group Past President 2006/2007 www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
This email made with 100% recycled electrons!
Miscellaneous Access "stuff" at www.ScoBiz.com