Have a look in your Control Panel/Administrative Tools/Data Sources. You may find that you have a Data Source called Excel Files under either the User DSN or System DSN tab. Using this, connector may be the simpliest way of achieving your desired results. Steve Jowett ------------------------- Real programmers don't comment their code. If it was hard to write, it should be hard to read.

Hi Allen Thanks you support I have create a new UserControl as you said ---------- Public Property Cols() As Integer Get Return Me._Cols End Get Set(ByVal value As Integer) Me._Cols = value Me.Invalidate() End Set End Property ------------------ on form design display property Cols, I don't know after that what I must todo Please help me ! :doh: This will appear at the end of articles you submit to the Code Project modified on Monday, July 28, 2008 3:42 AM

Are you absolutely, positivly, smack me in the face if i'm lying, sure you need 9000 columns ? This is not viewable or practical in any way ! Well. i was thinking about something like this: Dim dt As New DataTable For i As Integer = 1 To 9000 dt.Columns.Add(i.ToString) Next DataGridView1.DataSource = dt but you actually get an exception saying "sum of the columns "FillWeight" values cannot exceed 65535 For the rest however, the datatabe with the 9000 columns itself was build in something like 5 or 6 seconds...